Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    223
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Missing Controls (2000 sp3)

    One of the users of our rather large workbook app suddenly can't see the ActiveX button controls anymore when he loads the workbook. We use these buttons for navigation (primarily) and the code behind them hides and unhides various sheets. We have a mixture of Forms controls and ActiveX controls on some of the sheets; the Forms controls show up and work, the ActiveX ones don't.
    Is this a setting or option somewhere that might have accidentally been turned off on that one system? I searched for similar posts but didn't see any.
    Any ideas would help, thanks.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing Controls (2000 sp3)

    Tools, options, view tab, objects, show all?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    USA
    Posts
    223
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Missing Controls (2000 sp3)

    Thanks! That sounds very promising. However, when we rebooted and reloaded the workbook, they were there. This happened before I had a chance to check what you suggested. I will definitely check that the next time it happens.
    Thanks again

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing Controls (2000 sp3)

    Another thing to try next time (especially since you said the control-toolbox controls were missing!) is the temp folder. Control toolbox controls store a temporary picture file of themselves in the temp folder. Sometimes such a file may even get corrupted and prevent a workbook from loading. Cleaning out the temp folder resolves that.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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