Save as a new name and macros disable

[tiggatattoo]

Hi There,

I have a pretty extensive excel worksheet and I have set up buttons to view the worksheet in different ways. Hiding rows or columns or both in a few different ways. I have set up buttons with names and individual macros to display in multiple ways.

The problem I am having is that when I save as, and change the file name, all of the macros disable.

I want people to be able to name it what ever they want and have the macro's continue to work. I have attached the file.

If someone could please let me know how to fix this, that would be great.

Candace