View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
igor igor is offline
external usenet poster
 
Posts: 31
Default 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!
.