Button for Hyperlink

[Khalil]

Dear Experts:


I have a work book than contains around 10 worksheet, each sheet
linked with simple hyperlink. I am looking for professional
assistance to a add a click buttion (in vba) in stead of simple
hyperlink.You help will be higly beneficial me


Thanks in Advance

 

[Gord Dibben]

Many ways to do this.

Here are 3 ways.

You can right-click on the sheet navigation arrows and select from 15 sheets
or "more sheets".

Or you can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's site.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips..............my personal choice for a single button on a Toolbar.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP