shortcut to sheet?

G

Guest

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

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]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel shortcut options 0
Windows 10 How to create individual shortcut for each user 1
Using a Windows Shortcut to Open to Specific Sheet in Workbook 4
Desktop Shortcut to Specific Sheet in Excel 1
create multiple sheets using info from one 2
Merge Multiple workbook sheets into one workbook 0
PLEASE HELP - Link Data from Different Sheets to Summary Page 3
Switching between sheets in same workbook (Like Alt + Tab & Choose 4

Top