View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
a a is offline
external usenet poster
 
Posts: 51
Default Adding buttons while looping through files Question

Hello,

I have about 170 files that I need to loop through. In the loop I need
to add two buttons and assign macros to them. I can do the part about
assigning the macros, but, even when I just copy two identical buttons
and change their names, they never end up going to the spot where I put
them. I have to go back into the file and move them to their correct
location - which, as you can imagine - would be very, very time consuming.

I hate to attach the code - as it is kind of ugly, but it will give you
an idea of what I am trying to do as I may not be explaining it very
clearly. If the code is needed, please let me know.

Any help would greatly, greatly appreciated.

Thanks much in advance,
Anita