RJProfiteer
Board Regular
- Joined
- Aug 14, 2002
- Messages
- 85
I'm sure this has been done before because it could be a very useful tool and easy to construct............
I would like an msocontroldropdown on my toolbar that will list hyperlinks to my templates. That way it will be easy to load templates. (I have many templates and they are stored in many different folders)
The templates are listed as hyperlinks down the A column of my personal spreadsheet (the hidden sheet that loads automaticaly).
I have tested this manually with the
.additem "template1" command
and then have a if selected corresponding to it like
Set wkb1 = Workbooks.Add (template:="c:\sba\template1.xls")
The trouble with the manual approach is that the list of templates changes everyfew months and I don't want to edit code each time.
Can the additem refer to a list of hyperlinks? If so how?
Also I tried to do this with a dialog box listing the hyperlinks but then I would always be prompted to save the personal file at closing even though it wasn't changed.... So even if the toolbar-dropdown-hyperlink approach works referring to the personal file to get the hyperlink lists, can it be prevented from prompting me to save the personal file at closing?
Thanks in advance.
ray:
I would like an msocontroldropdown on my toolbar that will list hyperlinks to my templates. That way it will be easy to load templates. (I have many templates and they are stored in many different folders)
The templates are listed as hyperlinks down the A column of my personal spreadsheet (the hidden sheet that loads automaticaly).
I have tested this manually with the
.additem "template1" command
and then have a if selected corresponding to it like
Set wkb1 = Workbooks.Add (template:="c:\sba\template1.xls")
The trouble with the manual approach is that the list of templates changes everyfew months and I don't want to edit code each time.
Can the additem refer to a list of hyperlinks? If so how?
Also I tried to do this with a dialog box listing the hyperlinks but then I would always be prompted to save the personal file at closing even though it wasn't changed.... So even if the toolbar-dropdown-hyperlink approach works referring to the personal file to get the hyperlink lists, can it be prevented from prompting me to save the personal file at closing?
Thanks in advance.
ray: