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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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
540
RoryA
RoryA
M
  • Question Question
Formula Calculation is Inadvertently Switching from Automatic to Manual...
Replies
0
Views
261
MNexcelguy19
M
Dan Wilson
  • Solved
Unusual shortcuts in Excel
Replies
6
Views
689
Dan Wilson
Dan Wilson
S
  • Question Question
Shared workbook freezing when saving, but only for some.
Replies
0
Views
400
SingularitysPoint
S
M
  • Question Question
When I copy the excel file to another windows partition, it's not working
Replies
1
Views
110
ranman256
ranman256

Forum statistics

Threads
1,224,518
Messages
6,179,248
Members
452,900
Latest member
LisaGo

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