Macro to add Button

  • Thread starter Thread starter Lift Off
  • Start date Start date
L

Lift Off

Have a macro that crunches a file each day and saves the file as tha
day's date. I want to have my macro add a button to the daily fil
when it's run and the macro that's attached to the button reside in th
daily file. Not reside with my file that crunches the original file
which I close. Also, if I share the file, the button will work.

I can get the code to insert a button. But, how do I get my macr
which inserts the button, to write/add the code to the daily file t
attach the button too? Basically, the macro writes a macro for the ne
file.

Hope that makes sense.

Thank
 
Jim: That should do it! Sorry for the ignorance.

Thanks for your help, Clif
 
No need to appologize. We like to help. Just bookmark that site. It is a
great reference.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to call Excel add-in macro from a button… 1
application.activesheet, should I use it? 3
Re: Reference must be to a macro sheet? 0
Change macro button text when macro is invoked. 2
Command Button Question 8
Unable to assign macros to a new button in the current worksheet 1
Assigning macro buttons to macro code in another file 2
i need 1 macro button in master file to refresh data from all files 0

Back
Top