Create a Table of Contents In Excel Using VBA

The following macro not only creates a table of contents at the beginning of the workbook, but it also adds hyperlinks so […]

Protect or Unprotect All Worksheets At Once

If you want to protect or unprotect all worksheets in Excel, you only can do each worksheet manually. Is there any way […]

Print Worksheets VBA

In Excel, when you click the Print button, Excel will not print hidden sheets, except use VBA. Here is a large examples […]

Create a New Workbook for Each Sheet

Sometimes you may need to create a new workbook for each sheet, it seems very boring to do it manually, in this […]

Group Worksheets by Color

If you assign colors to your Worksheet tabs, you may want to sort or group Worksheets based on their tab colors, but […]

Sort Worksheets by Name

There's no built-in tool to alphanumerically sort Worksheets in Excel. If you want to sort worksheets by name, you need to drag […]

Move or Copy Worksheets VBA

In Excel, you can manually move or copy a worksheet to another workbook by right-clicking the selected sheet and selecting the Move or […]

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