Tag Archive: VBA Macros

Jan
15
2012

Assigning Excel 2007 Macros to Buttons / Trigger VBA Macros from Buttons

Excel macros are excellent time savers. It is a good idea to assign some keyboard shortcuts to trigger them quickly to make the most of them. Alternatively we can trigger them from buttons as well as well (if you find it difficult to remember too many keyboard short cuts). In this post I am going …

Continue reading »

Jan
15
2012

How to assign a keyboard shortcut for an Excel VBA Macro

Excel macros are excellent time savers. It is a good idea to assign some keyboard shortcuts to trigger them quickly to make the most of them. Assigning a keyboard shortcut when recording a macro If you record a macro, you will notice an option to assign the keyboard shortcut directly while naming your macro.   …

Continue reading »