Auto Save a Workbook Before Closing

This macro is an excellent way to protect users from inadvertently closing their file before saving. When implemented, this macro ensures that Excel automatically saves before closing the workbook. Excel normally warns users who are attempting to close an unsaved workbook, giving them an option to save before closing. However,…

Saving a Workbook When a Specific Cell Is Changed

Sometimes, you may want to save a workbook when a specific cell is changed or range of cells is changed. This macro allows you to define the range of cells that, when changed, forces the workbook to save. Macro Code to┬áSaving a Workbook When a Specific Cell Is Changed Private…

Creating a New Workbook Using Macro

Perhaps you may need to create a new workbook in an automated way. For example, you may want to copy data from a table and paste it into a newly created workbook. The below macro copies a range of cells from the active sheet and pastes the data into a…