Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Implant macro
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Implant macro
Resolved · High Priority · Version 2007
Reply Sat 11 Dec 2010, 07:46Delegate Tom said...
Tom has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Excel VBA Advanced course
Access Introduction course
Implant macro
I am creating a new wookbook via code. I want to set up a macro plus macro button on the new code-created workbook. How can I 'implant' the macro?
For upcoming training course dates see: Pricing & availability
RE: implant macro
Hi Tom, thanks for your query. Easiest way to quickly for this is...to record yourself doing precisely that as a macro! Here's the code I got from doing a quick macro of my actions:
ActiveSheet.Buttons.Add(218.25, 81.75, 117.75, 24).Select
Selection.OnAction = "mymacro"
Bit of an anti-climax, isn't it?!
Hope this helps,
Anthony
Reply Fri 17 Dec 2010, 07:56Delegate Tom said...
RE: implant macro
Thanks, Anthony.
Very helpful; i.e. works.
Anti-climax? Yes and no; it opens many doors.
Regards,
Tom
RE: implant macro
No problem Tom. Two lines of code, but a lot of potential. I hope it proves useful.
Anthony
|