close
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(quot;Sheet1quot;).Select
End Sub--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;MW_RedMosquot; gt; wrote in
message
...
gt; Can I create a shortcut to a sheet? I have a multi sheet book,
gt; can I create a
gt; desktop shortcut to open a particular sheet?
全站熱搜
留言列表
