Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert hyperlinks to commandbuttons via VBA
I wrote a "FAQ" page to an excel application that I am developing. I would
really like to make the worksheet unclickable when locking but as we all know--hyperlinks don't work unless you can select locked cells. I have found that all of my commandbuttons that act like hyperlinks work fine when pointed to specific cells (even though they are unclickable in protected worksheets) so I would like to convert all my hyperlinks to commandbuttons. I have about 100 hyperlinks throughout this worksheet. Does anyone know an easy way to do this via vba? I think it looks better and more professional for a user when a worksheet remains unclickable. I'll leave it the way it is if there is no easy way to do it. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert list of URLs to Hyperlinks | Excel Discussion (Misc queries) | |||
How to convert web addresses into hyperlinks | Excel Discussion (Misc queries) | |||
Convert text to hyperlinks | Excel Programming | |||
Convert Text to Hyperlinks | Excel Discussion (Misc queries) | |||
convert table of hyperlinks | Excel Programming |