How to add worksheet before another known worksheet that varies in location in file

[welchs101]

I have an excel file with many worksheet in this file. I have a "totals" worksheet which varies in location depending on who last viewed/used the file. What i want to do is add a new worksheet (called latest_month) so that this new worksheet is just prior to the "totals" worksheet. Does anyone know how to do this?

I found this code to add a worksheet just prior to the last worksheet in the file.....but i have not been able to modify it to work for my situation.

Please Login or Register  to view this content.

[hensucker]

Hello here you go buddy, assign this to a button or to run on workbook open, this will seek out the Sheets called totals, drop one sheet back and insert your new sheet called Latest_Month.

Please Login or Register  to view this content.

[Kelshaer]

Use this:

Please Login or Register  to view this content.

[welchs101]

thanks for the information!

[hensucker]

Anytime dont forget to Give Rep Where it's Due.

[welchs101]

i gave rep .........

[hensucker]

You sure did and Thank You.
Remember should you get stuck again, where here to Help!

[OnErrorGoto0]

Anytime dont forget to Give Rep Where it's Due.

Rep is entirely voluntary, so please don't hassle people to do it.

[hensucker]

Apologies to Welchs101 and the forum, strip my points.

[welchs101]

i know this item is closed but i have one more question.

The code suggested works fine.........but i have a question.

If i have more than one workbook open how do i specify which workbook i want to add this worksheet into.

[hensucker]

Well if this code is built into a module, that module would only be stored in the Workbook you have placed it in correct?
Else you could try

Please Login or Register  to view this content.

[welchs101]

thanks guys. that was it.

no need to strip away pts from anyone.......thanks for the help!