Macro assigned to a button question

[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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[igor]

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