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:
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!
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:
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!