Is there a way to have your sheet tabs into a drop menu?
G Gord Dibben Mar 26, 2009 #2 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
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
