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.
http://tinyurl.com/yoa3dw
Gord Dibben MS Excel MVP
On Thu, 26 Mar 2009 13:13:03 -0700, tleehh
wrote:
Is there a way to have your sheet tabs into a drop menu?