Workbook Tools

Check Save Status

This util checks the save status of all the open workbooks

Create New Customize Workbook

With this you can create your own customize workbook. There are 7 different options with a preview window on each to check your customization before you create your new workbook.

Delete Only Empty Sheets

With this you can delete all the empty sheets from the active workbook. There must always be at least 1 sheet in any excel workbook.

Delete Sheets Keep Active

With this you can delete all the sheets except the active one. Remember there must always be at least 1 sheet in any excel workbook.

Hide & Unhide Workbooks and Sheets

With this you can hide and unhide workbooks and sheets. You can make the sheets hidden or very hidden. You can also add, delete and rename sheets.

List Comments

With this you can create a list of all the comments in a workbook.

Named Range Lister

This utility lists all the range names. Click on each sheet to see that sheet’s name. You cab delete woth different options:

  • Delete All Names – this will delete all the range names in the active workbook
  • Delete Dead Names – this will delete all the dead names that have the value “#REF!”
  • Delete Linked Names – this will delete all the names that are linked to another file
  • Delete Selected Names – this will delete all the selected names in the second listbox. (Hold Ctrl to select multiple names)

Open Directory

With this you can open the folder where the active workbook is saved. This feature only works if the excel file is saved.