Set sequence of worksheets in WorkBook_Open
Posted on 2012-04-02
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,