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!

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

-----Original Message-----
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!
.