ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   convert hyperlinks to commandbuttons via VBA (https://www.excelbanter.com/excel-programming/431015-convert-hyperlinks-commandbuttons-via-vba.html)

dgold82

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.




All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com