Open a folder from the server from my personal.xls menu

jocoop

New Member
Joined
Oct 20, 2006
Messages
4
I have a personal workbook in my xlstart folder that gives me some custom tools. One thing I am trying to do is on my custom menu, I want to be able to open a folder with a subroutine (OpenFolder) from a network server. I have tried shell, which worked great for opening my .exe files, and I tried to put a hyperlink on a sheet, then run the hyperlink in the cell, but when I hid the sheet that broke it.

My server path is \\Sdc-svr1\Forecaster\StaffPlans

Thanks in advance for the great ideas.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,112,884
Messages
5,543,023
Members
410,583
Latest member
gazz57
Top