VBA – Adding useful shortcuts to VBA with MZ Tools

As I have already written in this article, the free MZ Tools add-in is a must for any VBA developer (or skilled secretary, as I have heard quite a lot). Anyway, in this article I will simply show how to make a shortcut with VBA for commenting and un-commenting of code with MZ Tools.

Once you install MZ Tools, if you do not see the side bar, go to Add-In manager and select it. Then, goto Options and select Shortcuts from the ribbon:

shortcut1

There you may simply select and add the button, to which you would like to add a shortcut.

Once, that is done, simply press OK and save it!

About

VBA Developer

Tagged with: , ,