reSequenceSheetsOnOpen-r1.xlsm

<div>
Thank you very much for your guidance and expertise.<br />
<br />
Michael
</div>


Thank you very much for your guidance and expertise.

Michael

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I have a workbook for distribution - I do not need to personalize the ribbon, but I do want to keep the worksheets in the same sequence. &nbsp;If the end-user should move them around - I would like to have them reset to my set sequence on Workbook_Open.<br />
<br />
They do not fall in alphabetic order and there are a few sheets that I want out of numeric sequence. &nbsp;I have 17 sheets - I do not mind having it layed out in 17 steps on Open to put them in sequence.<br />
<br />
Any help would be appreciated,<br />
Thanks
</div>
</div>


Hello Experts,

I have a workbook for distribution - I do not need to personalize the ribbon, but I do want to keep the worksheets in the same sequence.  If the end-user should move them around - I would like to have them reset to my set sequence on Workbook_Open.

They do not fall in alphabetic order and there are a few sheets that I want out of numeric sequence.  I have 17 sheets - I do not mind having it layed out in 17 steps on Open to put them in sequence.

Any help would be appreciated,
Thanks

Set sequence of worksheets in WorkBook_Open

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.