mtarggart,

I've had the same exact problem with my major project, unfortunately
the short answer to your question is no. because the menu with the macro
button will be kept with the excel application itself you can not do this.
However there are three solutions i know of.

1. If the menu with the macro button is stored in the workbook, AND only one
copy of the workbook, (Regardless of the name of the book) will be open at
one time, then you can add an Auto_close macro telling the workbook to
automatically delete the menu with the macros on it.

2. If you have more than one copy of the book open at one time, you can
Create and delete the menu each time the workbook is
opened/closed/activated/deactivated etc.... but this involves recoding also.

3. you can code everything into an .xla add-in and make the macros point to
that add-in.(this is similar to coding them all into the personal workbook
excel loads on startup)

ben







"mtarggart" wrote:

We have created an Excel program that uses macros to create packing slips and
box labels for the various customers we service. We have a master address
list (also an Excel sheet) that the program uses to populate the packing slip
and box label. The problem that we seem to be having is that when the packing
slips are saved as a different name and closed, then the original program
reopened, we have to reset the buttons to the macros. If we don't reset the
buttons and click on them, they will open the previous file that was saved.
Is there a way to amke the buttons run only the macros assigned to it and not
have them changed without rewiting the entire program?