Go to certain worksheet on opening workbook

[tuph]

I want to force a particular worksheet (tab name "Instructions") to be the front page of a workbook, even if the previous user saved and closed from a different worksheet.

I found this piece of code on the forum (thanks to whoever posted it )

Please Login or Register  to view this content.

and pasted it into a module, but it doesn't seem to work.

Thanks in anticipation!

[Trebor76]

Hi Trish,

The following code (which executes each time the workbook is opened) will do the trick:

Please Login or Register  to view this content.

HTH

Robert

[davesexcel]

Hi
That code belongs in the workbook module,
Check here to see where that is

http://www.contextures.com/xlvba01.html

should be more effective in the workbook open event though

[tuph]

Hi Trish,

The following code (which executes each time the workbook is opened) will do the trick:

Please Login or Register  to view this content.

HTH

Robert

This does exactly what I need. Thanks, Robert.

Thanks for the link, Dave. I'll check it out. I'm sure I'll find something useful in this steep learning curve I'm on.