View Single Post
  #4   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)

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?

"Barb Reinhardt" wrote:

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.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



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