G Guest Feb 16, 2006 #1 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?
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?
C Chip Pearson Feb 16, 2006 #2 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 message news:[email protected]...
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 message news:[email protected]...
