Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a command button to be a hyperlink
I want to have a command button act basically as a hyperlink, click th
button and it goes to a url specified in code. what i dont know i what code will do it. I have come up with Private Sub CommandButton6_Click() Dim h As Hyperlink Set h = ActiveSheet.Hyperlinks.Add(ActiveCell, "http://www.msn.com") h.Follow h.Delete ActiveCell.Clear End Sub the problem with this is because its writing and deleting from cells it will prompt when you close the workbook every time a button on th page has been clicked. I need a way of setting the hyperlink for tha button without doing anything that would cause excel to think the shee has been changed. thank -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
put a hyperlink on a command button | Excel Worksheet Functions | |||
Command Button Hyperlink | Excel Discussion (Misc queries) | |||
How do I execute command from button or hyperlink? | Excel Discussion (Misc queries) | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |