Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Control toolbox grayed out (XP)

    I have a spreadsheet that I have inherited. I want to add a button to execute some code but the controls in the control toolbox are grayed out.

    The sheet and the work book are not protected. Any ideas?

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

    Re: Control toolbox grayed out (XP)

    Is the workbook shared? That also disables most buttons on the Control Toolbox.

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control toolbox grayed out (XP)

    Hans,

    No the work book is not shared.

    Other info that may or may not be relevent
    The 'Enter/exit design mode' button, the 'Properties' button and the 'View Code' button all work but all the controls are grayed out and can't be selected.
    The work book does contain links to other data sources.

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

    Re: Control toolbox grayed out (XP)

    Please excuse me for asking these stupid questions: do you happen to have selected multiple worksheets?

  5. #5
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control toolbox grayed out (XP)

    Hans

    It's not a stupid question (given who you are dealing with). But no, I have only selected a single worksheet

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

    Re: Control toolbox grayed out (XP)

    Yet another one: Check the View tab of Tools | Options. If Objects have been set to Hide All, you won't be able to add controls.

  7. #7
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Control toolbox grayed out (XP)

    Bingo! That lit them up

    Thanks Hans

Posting Permissions

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