Pick a cell to go to a sheet in the workbook (greeting page)

[tom n.]

I have a workbook that has 10 different order sheets in it and want to make a
welcome page that customers can just pick the order type they need on the
greeting page and it takes them to the order sheet they picked.

 

[Barb Reinhardt]

Why not include a hyperlink to the page of interest. Under Insert ->
Hyperlink you can link to cells within worksheets or to a named range.

 

[Mike H]

Hi,

Additional to Barb's answer you might want to include this in the
workbook_open module to ensure your menu sheet is displayed each time the
workbook is opened. However, this does require the users to enable macros.


Private Sub Workbook_Open()
Sheets("Menu").Select
End Sub


Mike

 

[tom n.]

thank you worked fine. one more thing is their a way to hide all the sheets
and just keep the greeting page plus remove the save option?

 

[tom n.]

got thank you works fine

Hi,

Additional to Barb's answer you might want to include this in the
workbook_open module to ensure your menu sheet is displayed each time the
workbook is opened. However, this does require the users to enable macros.


Private Sub Workbook_Open()
Sheets("Menu").Select
End Sub


Mike