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
On Tue, 2 Jun 2009 10:15:08 -0700 (PDT), Khalil wrote:
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