Changing sheet names after macro coding has been done

[panserbob]

Hi,

I have created a budget workbook for the household, and in it are 36 work sheets. So I don't have to punch in the budget numbers each month, I coded a button which copies from the previous month, and it's working. However, I have called each of these sheets for the month plus the name of me or my SO (ex. "February John" or "March Jane") and these are the sheet names I've used in the macro coding. Now I want to give the workbook to a couple of friends so they can use it with their names, but how do I change the name of the sheets AND still keep the coding?

Thank for all the help

[Mumps1]

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file. At the very least, post a copy of your current macro.

[bakerman2]

Use the SheetCodeName (the name NOT between brackets in the Project Explorer) in your code instead of the Tab Names.

That way changing the Tabnames will not effect your code.

[panserbob]

That worked perfectly, thank you

[bakerman2]

You're welcome and thanks for rep+.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.