Unhide All Worksheets in a Workbook
If you want to unhide all Worksheets in a Workbook at once, this simple macro makes easy work for you. VBA Code […]
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 […]
Nightingale Rose Diagram Excel Template
Nightingale Rose Diagram is the most famous statistical diagram. It's a form of the Pie Chart now known as the Polar Area […]
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 […]