Defaul start up sheet on a workbook

[GeoN]

Does anyone know how to make a workbook open in the same
or default sheet every time is opened?

I have a workbook with 15 sheets. How can I make excel to
open it in the first sheet everytime I open this
workbook?....

Excel always remembers the last active sheet that the
workbook had open at the time it was save and close..

Anybody has any suggestions?

Thank you in advance

 

[Frank Kabel]

Hi
put the following code in your workbook module:
Private Sub Workbook_Open()
Worksheets("your_sheet").Activate
End Sub

and replace the sheetname
Frank

 

[GeoN]

Thank you for your reply but it didnot work..
The sheet name that I want to show when the workbook is
opened is "Instructions"

I have:

Private Sub Workbook_Open()
Worksheets("Instructions").Activate
End Sub

But it didn't work
Any other suggestion?

 

[Frank Kabel]

Hi
Have you put this procedure in your wokrbook module?
You may also add a messagebox to test if this procedure is invoked

Frank

 

[Guest]

Thank you very very much Frank. I really apprecaite your
help...

I put this procedure into a class module.. How do I place
it into a workbook module?

Thak u for you info.

 

[Frank Kabel]

Hi
Try the following:
1. If your VBA editor is opened where should be a topic 'ThisWorkbook'
in the left explorer window (above the modules). Double click this
entry to open the workbook module

2. Another way: Open your workbook. Righclick on the excel symbol left
to the menu entry 'File' and choose 'code'. This opens the VBA editor
with the workbook module

Frank