Auto Arrange Sheets

[dsexpress]

Hi All,
I have a templet sheet that is used over 30 times in a workbook. When multiple users edit and save, the sheets are not consistant to be scrolled though and viewed for review. Can anyone help with some code to get me started.

Thanks

[Leith Ross]

Hello dsexpress,

Here is a macro to put your worksheets in alphabetical order.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Press the keys ALT+F11 to open the Visual Basic Editor
4. Press the keys ALT+I to activate the Insert menu
5. Press M to insert a Standard Module
6. Paste the code by pressing the keys CTRL+V
7. Make any custom changes to the macro if needed at this time
8. Save the Macro by pressing the keys CTRL+S
9. Press the keys ALT+Q to exit the Editor, and return to Excel.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Sincerely,
Leith Ross

[dsexpress]

Thanks leith,
But what I was trying to accomplish was to have all the sheets named "DIFF" when opened to be in the same position on the screen. I would like to be able to click on the tab and veiw each sheet named "DIFF(N)"
for a quick visual scan so each "DIFF(N)" sheets table can be viewed on the screen without scrolling. When other users edit them, they are not saved in a set position, so I have to center the data manually in order to view.

[shg]

You could use the SheetActivate event in the ThisWorkbook module:

Please Login or Register  to view this content.

You could also use Zoom ...