Then, to the lower right of the screen, click the pin icon to pin the. Do any of the following: Show or hide the vertical scroll bar On the Excel menu, click Preferences. Other solutions for when Excel toolbars are missing Click on a tab to view the ribbon temporarily. By continuing to use this site you consent to the use of cookies on your device as described in our cookie policy unless you have disabled them. We use cookies to give you the best possible experience on our website. The setting applies to the current workbook but not to new workbooks. Lost menu tool bar in excel 2003 - Answered by a verified Programmer. The required icon/tools should now be visible on the toolbar/ribbon as before. By default, the horizontal and vertical scroll bars are shown. Change the drop down (4) to COM Add-ins (8).Step 2: Click Insert > Module, and paste the following macro in the Module Window. Step 1: Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window. Again in the File Tab (1) click Options (2) and Add-ins (3) If you are experienced with using Microsoft Excel, a VBA macro will help you display or hide status bar in Microsoft Excel easily.In the list of available toolbars, select the one you want to reset. The Toolbars tab of the Customize dialog box. If the item you wish to re-instate is not in the disabled items list then you will need to check if it has been de-selected. If you want to reset the Excel toolbars, perform these steps: Choose Customize from the Tools menu. Click the drop down (4) and chose Disabled Items (5).With the MS Office application open click File Tab (1) and Options (2).If you say OK to this the Add-in will go into the disabled items list. not part of basic MS Office functionality then you may be able to resolve the issue as follows: Check for Disabled Itemsĭisabled items can occur if the application you are working in encounters an error, it may then issue an alert message box that will inform you it wants to disable the item. If the item you are missing is an add-in i.e. This cell essentially acts as a search bar, allowing the user to type in what they are looking for rather than select it from a drop-down list. Have icons/tools disappeared from your MS Office Toolbar? Hi everyone, I found an excellent macro this morning that allows the user to filter a pivot table based on the value found in a specific cell.