| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut to sheet?
Can I create a shortcut to a sheet? I have a multi sheet book, can I create a
desktop shortcut to open a particular sheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shortcut to sheet?
You can use a macro to automatically open to a specific sheet. In
the ThisWorkbook code module, use Private Sub Workbook_Open() Me.Worksheets("Sheet1").Select End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "MW_RedMos" wrote in message ... Can I create a shortcut to a sheet? I have a multi sheet book, can I create a desktop shortcut to open a particular sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a shortcut to make a excel file open to a specific sheet | Excel Discussion (Misc queries) | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Linear Mode
