Hide All Worksheets Except Active One
Sometimes, you may need to hide all Worksheets except active one, if the Workbook have many Worksheets, it seems very boring to […]
Delete All Worksheets Except Active One
Sometimes, you may want to delete all Worksheets except the active one, if the Workbook have many Worksheets, it seems very boring […]
Add and Name a New Worksheet with Specific Name
If you always add and name a new Worksheet with specific name in your Workbook, sometimes it seems very boring to do […]
Excel VBA: Change Calculation Mode To Manual
Sub WorkbookCalculationManual() With Application 'Workbook calculation settings .Calculation = xlCalculationManual 'Change calculation mode to manual '.CalculateBeforeSave = True 'Recalculate workbook before saving, […]
Create a Backup of a Workbook with Current Date
We all know that making backups of your work is important. Now you can have a macro do it for you. This simple […]
Prevent the Workbook Closing If a Cell is Empty
Sometimes you may not want a user closing out a workbook without entering a specific piece of data. In these situations, you […]
Print All Workbooks in a Folder
Sometimes you may need to print all workbooks in a folder, open each workbook, print, close the workbook, and then open the […]
Open All Workbooks in a Folder
Sometimes you may need to go into your folder, open each workbook, edit, save it, close the workbook, and then open the […]