Editing your Macro Code 2

VBA or Visual Basic Applications is the programming language behind all office applications. By writing or editing this code you can take your macros to another level.

You can create some awesome macros by recording, but the real power lies in writing the VBA. Using VBA you can create complex macros that enhance the capabilities of Excel.

This tutorial covers;

• Understanding some of the VBA code generated by our protecting formulas macro
• Edit the code to tidy it up and correct mistakes
• Add an IF statement to exit the macro if the sheet is already protected
• Add the msgbox VBA function to display a message to the user upon exiting