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!!!

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!!!

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!!!