| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheets in Workbook
I have a workbook with multiple sheets which have been renamed. Is there a way to arrange the named sheets in alphabetical on the tool bar? Bob M. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheets in Workbook
I hope you do not really mean "toolbar" but just the row of tabs at the
bottom of the worksheet window. If so, look he http://www.cpearson.com/excel/sortws.aspx Need help with VBA? See David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "robert morris" wrote in message ... I have a workbook with multiple sheets which have been renamed. Is there a way to arrange the named sheets in alphabetical on the tool bar? Bob M. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheets in Workbook
Sorry, I did mean the row of tabs. Thanks for the link. I wil check there. Bob M. "Bernard Liengme" wrote: I hope you do not really mean "toolbar" but just the row of tabs at the bottom of the worksheet window. If so, look he http://www.cpearson.com/excel/sortws.aspx Need help with VBA? See David McRitchie's site on "getting started" with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "robert morris" wrote in message ... I have a workbook with multiple sheets which have been renamed. Is there a way to arrange the named sheets in alphabetical on the tool bar? Bob M. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheets in Workbook
Why do you hope that?
The worksheet tabs ARE just a toolbar: Commandbars("Workbook tabs") You can activate sheet "Sheet3" with Commandbars("Workbook tabs").Controls("Sheet3").Execute In article , "Bernard Liengme" wrote: I hope you do not really mean "toolbar" but just the row of tabs at the bottom of the worksheet window. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheets in Workbook
Thanks, Where would I enter the command to activate a sheet? Bob M. "JE McGimpsey" wrote: Why do you hope that? The worksheet tabs ARE just a toolbar: Commandbars("Workbook tabs") You can activate sheet "Sheet3" with Commandbars("Workbook tabs").Controls("Sheet3").Execute In article , "Bernard Liengme" wrote: I hope you do not really mean "toolbar" but just the row of tabs at the bottom of the worksheet window. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sheets in Workbook
Not saying you would, necessarily - that's only one way to activate. A
more straightforward way would be Sheets("Sheet1").Activate But you *could* enter either in the Immediate Window of the VBE. Or you could use either command in a macro. I was just pointing out that the worksheet tabs were indeed a toolbar... In article , robert morris wrote: Where would I enter the command to activate a sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| add new sheets in a workbook with new sheets being a variable | Excel Discussion (Misc queries) | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
| copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
Linear Mode
