98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Implant macro
Implant macro
Resolved · High Priority · Version 2007
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?
Wed 15 Dec 2010, 12:51Trainer Anthony said...
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
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
Fri 17 Dec 2010, 11:47Trainer Anthony said...
RE: implant macro
No problem Tom. Two lines of code, but a lot of potential. I hope it proves useful.
Anthony
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. |
Excel tip:Difference between Two DatesThe DATEDIF function computes the difference between two dates. The DATEDIF function is as follows: |
