ACC: How to Reset Toolbar Options

MORE INFORMATION

1. Create a macro called Reset Toolbars with the following action and arguments:
   

         Macro Name       Macro Actions
         ------------------------------
         Reset Toolbars   ShowToolbar
   
         Reset Toolbars Actions
         --------------------------
         ShowToolbar
            Toolbar Name: Database
            Show: Where Appropriate
   						

2. Click the selector (the box to the left of the ShowToolbar action) to select the ShowToolbar action.
3. On the Edit menu, click Copy.
4. Click Paste on the Edit menu 19 times to create a total of 19 ShowToolbar actions in the macro.
   
   NOTE: In version 2.0, click Paste a total of 18 times.
5. Change the Toolbar Name argument for the rest of the ShowToolbar actions to match the following table:
   

         ShowToolbar Action #   Toolbar Name Argument
         -----------------------------------------------
   
         In Microsoft Access version 7.0:
   
         2                      Relationships
         3                      Table Design
         4                      Table Datasheet
         5                      Query Design
         6                      Query Datasheet
         7                      Form Design
         8                      Form View
         9                      Filter/Sort
         10                     Report Design
         11                     Print Preview
         12                     Toolbox
         13                     Formatting (Form/Report Design)
         14                     Formatting (Datasheet)
         15                     Macro
         16                     Visual Basic
         17                     Microsoft
         18                     Utility 1
         19                     Utility 2
   
         In version 2.0:
   
         2                      Relationships
         3                      Table Design
         4                      Table Datasheet
         5                      Query Design
         6                      Query Datasheet
         7                      Form Design
         8                      Form View
         9                      Filter/Sort
         10                     Report Design
         11                     Print Preview
         12                     Toolbox
         13                     Palette
         14                     Macro
         15                     Module
         16                     Microsoft
         17                     Utility 1
         18                     Utility 2
   						

   
   NOTE: Setting the Microsoft toolbar to Where Appropriate will cause it to be shown in all views; therefore, you may want to set it to No.
6. Run the macro. All the toolbars will be reset to their original settings.