Workbook-specific toolbars

So far in this chapter, every change we’ve made to the Quick Access Toolbar has been a global change, meaning the commands will be available in every workbook that you open. You can also create toolbars that are specific to individual workbooks, which means that anyone else who opens the workbook will be able to access the custom toolbar. If you add Custom Views in the fashion I described in the previous section, most of the time, you’ll end up with a blank list consuming space on your toolbar. This technique requires Excel for Windows, as it is not possible in Excel for macOS. Here’s how to create a workbook-specific Quick Access Toolbar:

1. Access the Quick Access Toolbar section of the Excel Options dialog box.
2. Choose a workbook name from the Customize Quick Access Toolbar list above the second column, on the right-hand side, as shown in Figure 3.12:

Figure 3.12 – Workbook-specific Quick Access...