Macro assigned to a button question
 

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!

Macro assigned to a button question
 

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