Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button Question
Hello
My spreadsheet has a button menu page and the previous author created the buttons by using shapes. I am recreating and using forms controls and inserting actual buttons. There is one of his 'buttons' that is hyperlinked to a third party program. The hyperlink is formatted file:///\\path\filename.xxx. How do I assosciate this with a button? I suppose it will take a macro but I am not sure how to do it Thanks!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button Question
Try using Shell(path) in the buttons click event, it has focus arguments as
well. -- -John Please rate when your question is answered to help us and others know what is helpful. "Sandy" wrote: Hello My spreadsheet has a button menu page and the previous author created the buttons by using shapes. I am recreating and using forms controls and inserting actual buttons. There is one of his 'buttons' that is hyperlinked to a third party program. The hyperlink is formatted file:///\\path\filename.xxx. How do I assosciate this with a button? I suppose it will take a macro but I am not sure how to do it Thanks!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button Question
Assign this type of macro to your form:
Sub thirdparty() s = "file:///C:\Windows\Notepad.exe" ActiveWorkbook.FollowHyperlink (s) End Sub -- Gary''s Student - gsnu200755 "Sandy" wrote: Hello My spreadsheet has a button menu page and the previous author created the buttons by using shapes. I am recreating and using forms controls and inserting actual buttons. There is one of his 'buttons' that is hyperlinked to a third party program. The hyperlink is formatted file:///\\path\filename.xxx. How do I assosciate this with a button? I suppose it will take a macro but I am not sure how to do it Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button question | Excel Programming | |||
Formula/Button question | Excel Discussion (Misc queries) | |||
VBA Option Button question | Excel Programming | |||
X button question | Excel Discussion (Misc queries) | |||
question about custom button | Excel Programming |