Make a Work Sheet open as default?

[Legacy 154275]

Hi all I have tried the example in

http://www.mrexcel.com/forum/excel-questions/520295-default-worksheet-tab.html

but its not working, can somebody post an image please of exactly where this code should go?

 

[Jon von der Heyden]

Hi

That code goes in the ThisWorkbook module.

Open the VBE (ALT+F11)
Double Click ThisWorkbook
Paste the code in the code window that opens up.

 

[Legacy 154275]

Hi

That code goes in the ThisWorkbook module.

Open the VBE (ALT+F11)
Double Click ThisWorkbook
Paste the code in the code window that opens up.

Hi Jon I have done just that, but I will give it another go at home shortly. Thank you for helping

 

[Legacy 154275]

Hi Jon

Outstanding mate thank you its working fine now !!

Cheers