Workbook Manager

Use the workbook manager to easily keep track of all worksheets in all open workbooks.

Best practice

Navigation between worksheets in a workbook and between workbooks is much faster and easier if using the Workbook Manager than using Windows® Explorer.

The Workbook Manager can be found in the sheetRush task pane and consists of two tabs:

1. Open
   • This tab enables an easy navigation between all currently opened workbooks and their worksheets
   • The list at the top contains all currently opened workbooks
     • If a workbook is selected the worksheets of the selected workbook will be shown in the list below
     • You can easily jump to the workbook by using the GoTo button (first button) or a double click
     • The Save button (second button) saves the selected workbook, even without bringing the workbook to the front
     • The Close button (third button) closes the workbook. Before closing a save request may pop up, just as you are used to
     • The Open folder button (fourth button) opens the folder of the workbook
     • The Refresh button at the top of the workbook list reloads all currently opened workbooks. This may be useful if workbooks have been opened or closed in the background and the list is not up to date any more
   • The list at the bottom contains all worksheets in the selected workbook
     • The first column shows the worksheet name
     • The second column contains the GoTo button to quickly jump to the worksheet. You can also use a double click to jump to the worksheet
     • The third column contains the button to rename the worksheet
     • The fourth column provides a dropdown to move the worksheet. The sheet can be moved one position up or down, to the beginning or the end or to a specific position. To move the worksheet to a specific position select the worksheet in the list that should be before the worksheet.
     • The fifth column contains a dropdown to control the visibility of the worksheet
       • Visible: The worksheet is visible (default setting)
       • Hidden: The worksheet is hidden and can be unhidden using the Excel® controls
       • Very hidden: The worksheet is hidden using the VBA editor and can only be seen and unhidden within the VBA editor
     • The sixth column contains a dropdown to protect or unprotect a worksheet.
     • The seventh column contains a color picker control to select the tab color for the worksheet. Colors already in use by other tabs will automatically be suggested at the bottom of the color picker control.
     • The last column contains a button to delete the worksheet. This button is equivalent to removing the worksheet by deleting it from the Excel® workbook.
   • At the bottom there are two buttons to check or uncheck all worksheets and a dropdown-button to apply specific settings like visibility, protection or tab color to multiple worksheets at once.
2. Links

• The Links tab of the Workbook Manager shows all external links in the active workbook
  • The first column shows the name of the external workbook
  • The second column shows the state of the link to the external workbook. The available options equal them used in Excel®. Please refer to the Excel® documentation for further information. The available options are:
    • OK
    • File missing
    • Sheet missing
    • Out of date
    • Not calculated
    • Status n/a
    • Not started
    • Invalid name
    • Not open
    • Source open
    • Copied values
  • The third column contains the GoTo button. By clicking this button the external workbook will be brought to front. If the workbook is currently closed the workbook will be opened.
  • The fourth column contains the Open button. By clicking this button the external workbook will be opened if it is not already open.
  • The fifth column contains the Save button. By clicking this button the external workbook will be saved even without bringing it to front
  • The sixth column contains the Close button. Clicking this button will close the external workbook. Please note: This operation may trigger a save request in the external workbook, just the way as if you close the workbook manually.
  • The seventh column contains the Open folder button. By clicking this button the folder of the external workbook will be opened.