PC Review


Reply
Thread Tools Rate Thread

convert hyperlinks to commandbuttons via VBA

 
 
dgold82
Guest
Posts: n/a
 
      13th Jul 2009
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert footnotes to hyperlinks Lee Microsoft Word Document Management 1 15th Jun 2008 01:11 PM
RE: Convert text to hyperlinks =?Utf-8?B?QUZTU2tpZXI=?= Microsoft Excel Programming 1 19th Jan 2007 02:35 AM
Convert Text to Hyperlinks =?Utf-8?B?TGVlTWF4?= Microsoft Excel Misc 1 9th Nov 2006 11:01 PM
convert table of hyperlinks =?Utf-8?B?SmFrb2JzaGF2biBJc2JyYWU=?= Microsoft Excel Programming 1 23rd Jun 2006 12:03 AM
Loosing hyperlinks when I convert to PDF =?Utf-8?B?Q2hyaXN0aW5l?= Microsoft Word Document Management 6 7th Apr 2006 01:55 AM


Features
 

Advertising
 

Newsgroups
 


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