Macro assigned to a button question

  • Thread starter Thread starter Anita
  • Start date Start date
A

Anita

Hi,

I'm looping through a group of files and inserting a new module with new
macros. I'm also adding buttons. When I assign the macros to the
buttons - they reference the file that I am using to create the modules,
add the buttons and assign the macros.

Is there anyway around this? I think that I've done it before - but I
can't seem to remember how. It's driving me crazy.

Any help would be much appreciated!


Anita
 
Put your modules into personal.xls and then assign code to
the button. Once thats done your code should run for all
the files.
Regards
 
Back
Top