View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
tom n.[_2_] tom n.[_2_] is offline
external usenet poster
 
Posts: 4
Default Pick a cell to go to a sheet in the workbook (greeting page)

got thank you works fine

"Mike H" wrote:

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." wrote:

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.