Results 1 to 10 of 10
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hidden Auto Open Routine? (Excel 2000)

    Hi Everyone,
    I disabled a macro that set the number of decimal places in a spreadsheet and now I get an error message when I open the file - "Cannot find macro name" . To me that sounds like some other macro [perhaps an Auto Open] is looking for the disabled macro. However, the spreadsheet only has two modules, one for the now disabled macro and one for another routine that does not call the now disabled routine. The This Workbook object has nothing in it. Could there be another place for an Auto Open routine? Any Ideas? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    TIA
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  2. #2
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden Auto Open Routine? (Excel 2000)

    How did you disable it?

    Edited to include the following...

    It is possible, depending on the code in the modules, that some of the code is triggering an event which calls the macro you disabled.

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

    Re: Hidden Auto Open Routine? (Excel 2000)

    The Open event routine is in the ThisWorkbook object. In the VBE find the ThisWorkbook object in the project browser. Right click on it and click on "View code" in the pop up menu. In the left hand drop down list that probably displays "General", select "Workbook" from the drop down list. In the right hand drop down list select the open event to view the code.

    Also, when you get the error, is there a button in the error box labeled Debug? If there is, clicking that button should take you to the code that is trying to run the macro.
    Legare Coleman

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden Auto Open Routine? (Excel 2000)

    Mike,
    I disabled it by commenting out the code. I tried to attach an abbreviated version of the file but for some reason can't get in down to the required 100k. I even tried removing all the modules and the file is still 146k and I still get the error message! I'm stumped.
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden Auto Open Routine? (Excel 2000)

    Legare,
    I did as you said but don't see anything. The error message only has an "OK" button. In an effort to make the file small enough to attach [to no avail] I removed all the modules. I still get the error message. Now I'm really confused!
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

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

    Re: Hidden Auto Open Routine? (Excel 2000)

    Have you tried creating a .zip file and attaching the .zip file instead of the .xls itself? WinZip usually achieves a 50% to 80% compression rate on Excel files.

  7. #7
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden Auto Open Routine? (Excel 2000)

    Are you sure you are in the right project. If you have an add-in running or another workbook open, there will be more than one project. The Open event is in the ThisWorkbook object as Legare says.
    Attached Images Attached Images

  8. #8
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden Auto Open Routine? (Excel 2000)

    Here is the file [Thanks Hans, for the zip file reminder]. I don't see a thing. I will be curious to see if you get the error message.
    Attached Files Attached Files
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Hidden Auto Open Routine? (Excel 2000)

    Hi Sherry,
    You have a defined name Auto_Activate in your workbook which refers to a non-existent range/macro called Inventory_Cursor_Decimals. If you delete the Auto_activate name, the error should go away.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hidden Auto Open Routine? (Excel 2000)

    Sheesh! Am I embarrassed!! <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    Thanks everyone!!
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

Posting Permissions

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