Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

    Lock Toolbars ? (Excel XP)

    Is there a way to lock the toolbars so they can't be inadvertantly moved ? I occasionally accidentally drag my toolbars away from their docked location across the top of the screen.

    Thanks,
    BH Davis

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lock Toolbars ? (Excel XP)

    To lock the Standard toolbar:

    Press Alt+F11 to activate the Visuyal Basic Editor.
    Press Ctrl+G to activate the Immediate window.
    Type (or copy/paste)

    CommandBars("Standard").Protection = msoBarNoMove

    and press Enter while the insertion point is anywhere in that line, If you want to unlock:

    CommandBars("Standard").Protection = msoBarNoProtection

    You can do the same for the "Worksheet Menu Bar" and for the "Formatting" toolbar, and others if you show them.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Lock Toolbars ? (Excel XP)

    As always my persoanl tutor is there to help me !!!!!!!!

    Thanks,
    BH

Posting Permissions

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