Making a workbook always open on the same worksheet?

[Mat 66]

Does anyone know how you can force a workbook to always open on
certain sheet? i.e. a contents style sheet.

Cheers All

 

[Frank Kabel]

Hi
put the following code in your workbook module (not in a
standard module):
sub workbook_open()
me.worksheets("content_sheet").activate
end sub

 

[Toby Erkson]

Save the workbook with that particular sheet visible.
Toby Erkson
Oregon, USA

 

[Mat 66]

Cheers Frank works a treat