How to create a Windows Shortcut to a specific Worksheet?

J

jrwpmw

New Member
Joined
Jan 11, 2010
Messages
19
I can easily of course create a shortcut on my desktop to a Excel file.

I can also create a hyperlink to a specific worksheet in a workbook - by using: ....filename.xls#worksheetname

However, when I try to create a shortcut to a specifc worksheet, it doesn't work. It will open the Excel file but not open the specific worksheet. The problem is that the windows shortcut seems to try to read the #worksheetname as part of the file.

With the #worksheetname in the shortcut, windows says file not found, with it off the shortcut works fine.

Any ideas? All I want to do is create a shortcut that opens to a particular worksheet?

Thanks as always!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
Thanks, that is the exact same problem. I don't have any special characters, just a Defined Name to a cell on the worksheet, like .....#ISSUELOG

That works fine in hyperlinks, just not in a windows XP shortcut.

I an running office 2003 on XP.

If anybody else has any ideas it would be appreciated!

Thanks!

UniMord said:
I was looking for the same thing a few months ago, but got nowhere.

Look at this thread: http://www.mrexcel.com/forum/showthread.php?t=538609
Click to expand...
 
Upvote 0
You could also use a simple vbs to automate an Excel instance opening to the selected file location

1)Put the following code into NotePad, save the file somewhere convenient with a file name ending in vbs.
ie
MyFile.vbs

Change you Excel File path and sheet/cell position to suit

Code: 
Set objXl = CreateObject("Excel.Application")
Set ObjWB = objXl.Workbooks.Open("C:\test\testfile.xlsm")
objXl.Goto ObjWB.Sheets(2).Range("A1")
objXl.Visible = True

2) Create a new shortcut, then point it at the MyFile.vbs you just created

Cheers

Dave
 
Upvote 0
Thank you, that's a winning approach, and puts my convoluted efforts to shame. I had no idea that you could even do this with a VBS file.

The advantages of your script are, that since it doesn't require a VBA macro to run, I can use it with a .XLSX file, and send it to users who don't have macros enabled.

I'm theorizing (and hoping!) that it is still possible that there is a possible use for the VBA/CMD solution, in the case where WSH/VBS is disabled (not unusual).
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Create Shortcut to Excel & an Excel file using VBA
Replies
4
Views
219
RoryA
RoryA
Dan Wilson
  • Solved
Unusual shortcuts in Excel
Replies
6
Views
281
Dan Wilson
Dan Wilson
B
  • Solved
Macro to open other Excel files, run a specific Macro, and close?
Replies
2
Views
252
Bret1
B
C
  • Question
search, copy, open Window explorer, paste in the address bar, and open file
Replies
6
Views
205
RoryA
RoryA
M
  • Solved
Normal access to sheet but with hidden tab/shortcut
Replies
2
Views
423
mrfahaji
M

Forum statistics

Threads
1,214,621
Messages
6,120,568
Members
448,972
Latest member
Shantanu2024

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top