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?

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" <[email protected]> wrote in
message
news:[email protected]...
> 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?