Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compile Error in Module:UI (Excel 2000 SR-1)

    First of all I followed the Approach to Behavioral Problems in Excel. But, I'm still stumped. I ran Excel in "safe" mode and it works. I deleted all files in XLSTART folder. I renamed *.XLB files. I disabled Add-Ins
    .
    Here is the error:

    When I open Excel, either from a file link, or by itself, it will open. Then I get this error:

    Window Title: Visual Basic Error
    Message: Compile error in Module: UI

    If I click on OK for the error, the error box closes, and Excel works fine for the most part (meaning I did not go into a long testing session of the excel program itself).

    But when I close Excel, the message comes up again.

    Can anyone help???

    Chris

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

    Re: Compile Error in Module:UI (Excel 2000 SR-1)

    One other thing I can think of to look at. Select "Options..." from the Tools menu. Click on the General tab. Look in the text box labeled "Alternate startup file location." If there is anything in this box, find the directory that it is pointing to and remove all files from that directory, or remove the text from the text box. Close Excel and restart it to see if the problem still exists.
    Legare Coleman

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

    Re: Compile Error in Module:UI (Excel 2000 SR-1)

    Another thing to check: There may be more than just one XLSTART folder.

    Mine are:

    Cocuments and SettingsPieterseApplication DataMicrosoftExcelXLSTART

    and (for XP):

    C:Program FilesMicrosoft Office XPOffice10XLStart
    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
  •