Force Excel to direct user to a specific worksheet upon opening

Originally Posted by somesunnyday

Hi davesexcel,

I tried your tip but it didn't seem to work. I've attached the spreadsheet. Are you able to tell if I did it correctly or not?

Cheers

Follow the link in my 1st post to see where the workbook module is.
here it is again......
http://www.contextures.com/xlvba01.html#Workbook

Originally Posted by somesunnyday

I did follow the instrcutions in your link orginally and pasted the code. I then renamed the "Sheet 1" section to no avail.

Here is your example with the code in the correct place