Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Thanked 0 Times in 0 Posts

    Resetting All Office Toolbars (Office 97 & 2000)

    This Question is about Word 97 & 2000, Powerpoint 97 & 2000, Excel 97 & 2000 and Publisher 97 & 2000.

    I help out in a local school working with the computers, I am only there a few hours a week and the kids "customise" play about with any MS Office programs they are using hiding and deleting toolbars.

    What I would like to do is use VBA to reset the toolbars when any MS Office program closes or starts, is this possible and how do I do this for each of the listed programs.

    Thanks Graham

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: Resetting All Office Toolbars (Office 97 & 2000)

    I don't know about the others, but for Excel you can do something like:

    <pre> CommandBars("Standard").Reset
    CommandBars("Standard").Visible = True

    For each command bar.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts