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 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 […]