Order of the Worksheet tabs across the bottom of the screen

  • Thread starter Thread starter Rich Mogy
  • Start date Start date
R

Rich Mogy

Hi All,
Is there a script that I could write that would put the worksheet tabs in
the order that I want them across the bottom of the screen.

Thanks in advance

Rich Mogy
 
Sure. Just use the Move method. E.g.:

Sheets("SheetTheFirst").Move Before:=Sheets("SheetTheSecond")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming work sheet the name as sub-routine that creates it 4
Tracking Changes 2
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Hiding tabs for just some sheets. 4
Editing an "IF" function across a worksheet/excel file 2
Printing/# pages inclusive of tabs at bottom 1
Tabs in alphabetical order 5
Linking spreadsheets and returning value to "0" if no info 6

Back
Top