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 Training and help » Macros
Macros
Resolved · Medium Priority · Version 2007
Mon 9 Nov 2009, 16:02Delegate Graham said...
Graham has attended:
Excel Advanced course
Macros
How can I assign a macro which I have already authored to an Active-X Button on the worksheet?
Mon 9 Nov 2009, 21:59Trainer Simon said...
RE: Macros
Hi Graham,
Thank you for your question.
You right click over the active x button in design view and choose view code and then you copy and paste the macro code into the button procedure.
Alternatively, go to the Developer tab and then Insert and add a button from the Form Controls group.
I hope this answers your question.
Regards
Simon
Mon 16 Nov 2009: Automatically marked as resolved.
Training information:
See also:
|
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:Shortcut for accessing recently opened filesTo get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu. |
