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