Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting label to open folder
I would like to have a label that, when selected, a named
folder would open. I know how to do this with a hyperlink through excel but not using a macro. Does anyone have any suggestions? Thanks in advance. Joe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting label to open folder
Put an ActiveX label control on a form.
While in design mode double click the label In the click event insert something like the following: Shell ("explorer " & "c:\"), vbNormalFocus Go out of design mode and click the label. You should see a directory listing of the c root (in this case) appear. If it's actually a file requester you want to display try: FileName=application.GetOpenFilename -- Regards, Bill Lunney www.billlunney.com "Joe" wrote in message ... I would like to have a label that, when selected, a named folder would open. I know how to do this with a hyperlink through excel but not using a macro. Does anyone have any suggestions? Thanks in advance. Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open a Folder | Excel Discussion (Misc queries) | |||
setting excel 2007 default template folder | Setting up and Configuration of Excel | |||
Setting a path to a folder | Excel Discussion (Misc queries) | |||
Problem setting BackStyle on Label | Excel Discussion (Misc queries) | |||
Setting a default save folder for a template | Excel Discussion (Misc queries) |