Skip to main content
Learn
Creating a Custom Ribbon
You can't modify the Ribbon using VBA alone. Instead, you must write RibbonX code and insert the code into a workbook file […]
Learn
Excel Macro: Search on Google
If you want to use VBA to open Google Chrome and search keywords on Google, the following Macro do this. Search on […]
Learn
Excel Macro: Protect or Unprotect All Worksheets At Once
Is there any way to have a Macro protect or unprotect multiple worksheets at once in Excel quickly and easily? This Macro do this! Get it now!
Learn
Excel Macro: Add and Name a New Worksheet with Specific Name
If you always add and name a new Worksheet with specific name in your Workbook, this simple macro can help you. Get this VBA code now!
Learn
Excel Macro: Prevent the Workbook Closing If a Cell is Empty
If you want to to make sure the user has entered all the required fields before saving and closing Excel. This is where this macro comes in.
Docs
MsgBox function
Displays a message in a dialog box, waits for the user to click a button, and returns an Integer indicating which button […]
Learn
Excel Macro: Auto Save a Workbook Before Closing
This macro ensures that Excel automatically saves before closing the workbook. Get this VBA code now!