| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pick a cell to go to a sheet in the workbook (greeting page)
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pick a cell to go to a sheet in the workbook (greeting page)
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pick a cell to go to a sheet in the workbook (greeting page)
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book | Excel Worksheet Functions | |||
| Page set up for a workbook, so each sheet gets the same format ? | Excel Worksheet Functions | |||
| How do I pick the same cell in sheet 1!, Sheet2! and just drag | Excel Worksheet Functions | |||
| sheet tabs as page number and in a cell page of pages? | Excel Discussion (Misc queries) | |||
| How can I print page 2 of each sheet in a workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
