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

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

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 " wrote in
message ...
Hi everyone,

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

Thanks in advance.

Scott.


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

Thanks all, everything now working perfectly!

Scott

--
Message posted from http://www.ExcelForum.com