ExcelBanter - shortcut to sheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - shortcut to sheet? (https://www.excelbanter.com/excel-discussion-misc-queries/72083-shortcut-sheet.html)

MW_RedMos

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?

Chip Pearson

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?

All times are GMT +1. The time now is 10:10 PM.