+ Reply to Thread
Results 1 to 3 of 3

Anyway to create shortcut icon to open a specific worksheet?

  1. #1
    Registered User
    Join Date
    03-17-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    74

    Anyway to create shortcut icon to open a specific worksheet?

    Hello,

    Is there anyway to create a shortcut icon that I can place on my windows Desktop - That when launched will open a workbook to a specific worksheet/tab.

    Has to be a windows shortcut as the workbook is auto generated eachday and sent to me, so if I add vb code it will not matter as I will get a new workbook the next day thus wiping out the vb code.

    The person who compiles it leaves it on a certain tab that I dont need, but is commonly used by other people - so I would like a shortcut to skip that worksheet and take me to the worksheet that I need to use. No biggie if it cant be done! An answer either way would be cool! cheers
    Last edited by ebbo; 08-17-2009 at 08:27 AM. Reason: Solved

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Anyway to create shortcut icon to open a specific worksheet?

    If you can use a vbscript file then yes.

    create a text file called LaunchMyFile.vbs containing the following code with folder, workbook and sheet set to relevent names.

    Please Login or Register  to view this content.
    your desktop shortcut points to the LaunchMyFile.vbs
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-17-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    74

    Re: Anyway to create shortcut icon to open a specific worksheet?

    thank you very much, thats working without a blip cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1