View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Command Button Hyperlink

PERFECT!!

Thanks so much Dave,

Brad

"Dave Peterson" wrote:

How about something like:

Option Explicit
Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink Address:="http://www.yoursite.com"
End Sub

You might want to do the same thing with a label--format it blue underline so
that it looks like a hyperlink. It might be more familiar to users.



Brad wrote:

Thanks for taking the time to read my question.

Is it possible to have a button on a form act as a hyperlink?

If so, how do I do this?

Thanks,

Brad


--

Dave Peterson