98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Macros
Excel - Macros
Resolved · Low Priority · Version Standard
Tom has attended:
Excel Advanced course
Excel - Macros
I have recorded a macro but neglected to assign a shortcut key. I would now like to do this, is there something I can add to tne VBA coding to do this.
RE: Excel - Macros
Hello Tom,
I hope you enjoyed your Excel training session with us.
To answer your question, it actually isn't even necessary to alter the VBA to change your keyboard shortcut on your macro. To create or edit the shortcut, go to Tools > Macro > Macros. Find the macro you want to assign the shortcut to, and click options. Here, you can change the shortcut.
I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.
Have a great day.
Regards,
Mara
Microsoft Office Specialist Master Trainer
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:How to Spell Check an Excel 2010 WorksheetExcel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet. |