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" <MW_RedMos@discussions.microsoft.com> wrote in
message
news:55C0B41B-3EAE-4A3B-B81A-4C14BEFBA82F@microsoft.com...
> 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?