Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

Excel: Direct Access to Sheets

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
pnh73
Asked:
pnh73
1 Solution
 
Steve KnightIT ConsultancyCommented:
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now