You can use the right-click on the navigation arrows or 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.

http://tinyurl.com/yoa3dw

I'm kinda partial to Bob's method.


Gord Dibben MS Excel MVP

On Wed, 5 Mar 2008 02:36:01 -0800, kay505
wrote:

E.g. Creat a list of buttons/links on Sheet1 to take me directly to Sheet2.