Home » On Error statement
Excel Macro: Adjust All Pivot Data Field Titles
When you create a PivotTable, Excel prefixes the title of each data field with Sum of, Count of. If you want the […]
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: Limit The Number of Times a Workbook Can Be Used
Suppose you want to send a demo file for users to check, but you don't want it to be used more than […]
Workbook.FullName property Kill statement Workbook.ChangeFileAccess method DocumentProperties.Add method Choose function MsoDocProperties enumeration Workbook.CustomDocumentProperties property Workbook.BeforeSave event Workbook.RemovePersonalInformation property Workbook.Close method Workbook.Saved property Workbook.Open event Workbook.Save method With statement If...Then...Else statement On Error statement
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: Highlight the Active Row and Column
The VBA code examples show ways to highlight the active cell or the rows and columns that contain the active cell. Get the VBA code now!
Range.Column property Range.CurrentRegion property Range.Select method Range.EntireColumn property Range.EntireRow property IsEmpty function Worksheet.SelectionChange event Worksheet.BeforeDoubleClick event Application.ScreenUpdating property Interior.ColorIndex property Range.Interior property Range.Address property On Error statement
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: Create, Copy, and Delete Folders
We can create, copy and delete specified folders using Folder object or FileSystemObject object in VBA. 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 […]