Startup

S

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
 
G

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
 
J

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
 
Top