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?