Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Objects & Code Oh My (97:Sr2)

    I have a checkbox1 created with control toolbox that is misbehaving. On PC01 upon opening the file I can not click or check the object box to return a True/False. I also have code that does not work. Code such as Sheets("AnySheet").Select. On PC02 it works fine. Both PC01 and PC02 have the same operating system (Wk2) and XL 97.

    I don't want to ask but is this virus related? I have run the virus protection software and did not received a virus warning.

    Thanks,
    John

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

    Re: Objects & Code Oh My (97:Sr2)

    A virus wouldn't be my first guess. It may be a references problem.

    Open the workbook on PC01 (the one with the problem).
    Activate the Visual Basic Editor (Alt+F11)
    Select Tools | References...
    Do you see one or more references starting with MISSING?
    If so, select each in turn and write down the details in the lower half of the dialog, then clear the check box for that reference.
    When you have unchecked all MISSING references, click OK.
    See if the workbook functions OK now.
    If not, please post the names and details of the MISSING references.

    If there were no missing references, we'll have to investigate further.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Objects & Code Oh My (97:Sr2)

    Hans,

    I thought of that and as one would expect there was nothing missing. All references check out.

    John

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Objects & Code Oh My (97:Sr2)

    It may well be that PC01's installation of Excel has become corrupted. We have a <!post=Star Post,290455>Star Post<!/post> on problems with Excel by <!profile=pieterse>pieterse<!/profile>. This does deal with problems on starting up Excel but, about half way down he mentions "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver. You could try running that command from Start|Run. (If PC01's path to Excel is something else, the part in quotes needs to be altered. HTH
    Gre

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

    Re: Objects & Code Oh My (97:Sr2)

    You did enable macros on the offending PC, right?
    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
  •