Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting sheet tab order based on sheet name
I have five sheets which I want to display in the following order:
# SheetName 1 Report 2 Project Listing 3 Project Analysis 4 Committed 5 Uncommitted Is there a clean way to do this? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting sheet tab order based on sheet name
Something like this...
Sub PositionSheets() Dim varNames As Variant Dim N As Long varNames = Array("Uncommitted", "Committed", "Project Analysis", _ "Project Listing", "Report") For N = LBound(varNames) To UBound(varNames) Sheets(varNames(N)).Move befo=Sheets(1) Next End Sub -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware wrote in message I have five sheets which I want to display in the following order: # SheetName 1 Report 2 Project Listing 3 Project Analysis 4 Committed 5 Uncommitted Is there a clean way to do this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Populate order sheet with data from work sheet | Excel Worksheet Functions | |||
Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming | |||
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X | Excel Programming |