Startup

[scottwilsonx]

Hi everyone,

Does anyone know how to write a vba code that will ensure that
spreadsheet always open on a particular page - in this case a menu pag
?

Thanks in advance.

Scott

 

[GregJG]

if what your looking for is that you when a workbook is opened , i
always opens on the same sheet and a certain cell. this is the code.


Private Sub Workbook_Open()

Sheets("Name").Select
Range("A1").Select

End Su

 

[JulieD]

Hi Scott

this code pasted in the "this workbook" sheet will cause the workbook to
display the index sheet (or replace index with the sheet name that you want
displayed)

Sub workbook_open()
Sheets("Index").Activate
End Sub

Cheers
JulieD

 

[scottwilsonx]

Hi all, thanks for the feedback. Everything now working perfectly

 

[scottwilsonx]

Thanks all, everything now working perfectly!

Scott