ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sheet tabs (https://www.excelbanter.com/excel-worksheet-functions/225705-sheet-tabs.html)

tleehh

sheet tabs
 
Is there a way to have your sheet tabs into a drop menu?

Gord Dibben

sheet tabs
 
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?




All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com