First, you need to add the sub procedure (macro) that displays the list, as follows: If you want to turn off the sheet tabs but still allow users the ease of jumping to sheets via the Sheet Navigation list, you can add a macro that displays the same list. Turning off the Sheet Navigation Toolbar is a consequence of disabling the sheet tabs. TechRepublic's Microsoft Office Suite newsletter, delivered every Wednesday, is designed to help your users get the most from Word, Excel, and Access. Click the File tab and choose Options (under Help).In the Display Options For This Worksheet section, uncheck Show Sheet Tabs.Click the Office button and click Excel Options.Uncheck the Sheets Tab option in the Windows Options section.The Sheet Navigation toolbar is available by default, but the sheet's creator can turn off this display as follows: Simply select a sheet in the list to select that sheet. Excel will display a list of all the sheets in the workbook, with the current sheet checked. Right-click the Sheet Navigation toolbar. You can use the keyboard shortcuts + and + to scroll through the sheets, but with lots of sheets, that can take awhile. Of course, you can click a sheet tab, but if you have a lot of sheets, they're not all visible. Moving from sheet to sheet is just as easy, but perhaps not as intuitive. There are a number of ways: scrolling,, the Name box, arrow keys, and so on. Moving around in an Excel sheet quickly becomes second nature.
