Skip to main content
Excel Macro: Hide All Subtotals in a PivotTable
This simple macro hides all subtotals in the specified PivotTable. Tips You can manually hide all subtotals at once by going to […]
Excel Macro: Enable Trust Access to the VBA Project Object Model
Enabling trust access to the VBA project object model allows you to write automated Excel programs and manipulate the VBA environment and […]
Excel Macro: Create a Table of Contents of Sheets
This Excel macro not only creates a table of contents at the beginning of the workbook, but it also adds hyperlinks. Get this VBA code now!
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!
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!
Excel Macro: Rename a File or Folder
You can rename and move a specified file or folder using the built-in Name statement in VBA. Download this Excel macro now!
Excel Macro: Determine If a Excel Workbook is Already Open
This Excel custom function can be used to determine if a excel workbook is already open or not. Get this VBA code now!
On Error statement
Enables an error-handling routine and specifies the location of the routine within a procedure; can also be used to disable an error-handling […]