?
Solved

Excel: Direct Access to Sheets

Posted on 2003-03-26
1
Medium Priority
?
153 Views
Last Modified: 2006-11-17
I have an Excel spreadsheets with around 40 sheets. These are worked on by other people and i only need to access one of them (a graph). Is there anyway i can create a direct shorcut from my desktop to the specific sheet within the excel workbook?

Paul
0
Comment
Question by:pnh73
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 43

Accepted Solution

by:
Steve Knight earned 150 total points
ID: 8212970
I've got one where I check my username to run a macro on opening the sheet.  You could do similar, e.g.:

Paste this into the ThisWorkbook area of VBA.  ALT F11 to get to the VBA editor then double click into ThisWorkbook from Project Explorer (Control R if not open).

Private Sub Workbook_Open()
If Application.UserName = "Steve Knight" Then
    Sheets("Chart1").Activate
End If
End Sub

I don't know a direct way of calling a macro or moving to a named range from a commandline shortcut (I thought you could use #XYZ where XYZ is a named range but maybe someone else does know...

Steve
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question