Results 1 to 13 of 13
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    The Land of Pleasant Living, Maryland, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Disable non-existant macro in Excel 2000

    I updated an Excel 2000 spreadsheet and removed the only macro that it contained, however whenever I open this spreadsheet I'm asked whether I want to enable or disable the macros (which are no longer there!).
    I can click on TOOLS-MACRO-MACROS and no macros are listed.
    I checked Woody's Using Office 2000 but no luck.
    Anyone have an idea?
    Peace,
    Tony

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    Is there still a module shown attached to the worksheet?
    You might need to delete that as well.

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    The Land of Pleasant Living, Maryland, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    Thanks for the prompt reply.

    I think you might be on to something BUT I'm an ol' Quattro Pro type converted to Excel and have no idea what a "module" is and whether there is one attached to this sheet. The file WAS updated from an old version of Excel and the "Help" menu seems to say that a module may have been created in the conversion process.

    How can I tell if there is a module attached and if so how do I delete it?

    Peace,
    Tony

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    OK. With Excel running and the relevant worksheet active, hit Alt-F11 to bring up the VB window - should look something like the attached.
    On the left pane, you should see the worksheet listed - you may need to hit the '+' markers to expand it, and you should see something like "Module1".
    Make sure it is selected, the go File, Remove Module1.
    Select No to export, and it should be gone.
    (If you are not sure, create a copy and do a practice run).
    Just shout if you need more help.
    Attached Images Attached Images

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    The Land of Pleasant Living, Maryland, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    Thanks again for the post - and I thought you were on to something BUT it still asks to disable the macro that isn't there.

    I followed your excellent directions and found FIVE modules attached to the spreadsheet. I deleted them all and saved the changes but when I reopen the file - It still asks UGH!

    Any other ideas?

    Peace,
    Tony

  6. #6
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    OK - maybe silly questions time, but:
    Are you opening the worksheet as a link (i.e. starting Excel at the same time) or opening it with Excel already running?
    Click on the 'ThisWorkbook' icon in the left pane and see if there are any macros set to run (e.g.) when the workseet opens.
    Try copying the contents from the worksheet to a new blank one and see if that still brings up the warning.

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Location
    The Land of Pleasant Living, Maryland, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    I generally open Excel and then the worksheet.

    I clicked on "This Workbook" and the right side is blank - I ASSUME this means no macros.

    How is the best way to copy the workbook (2 pages) to a new workbook without loosing column widths, formatting, etc.?

    Thanks again - I'm amazed at the speed of your responses.

    Peace,
    Mike

  8. #8
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    Open a new workbook
    Go to the one you want to copy and click the unmarked square to the left of A and above 1 - this 'Selects All'.
    Edit/Copy.
    Go back to the new workbook, click the same point to 'Select All' and go Edit/Paste.
    This should plonk in a carbon copy.
    **
    I'm officially loafing (Chicken Pox - hence the temp. pic) so no-one is expecting me to get much work done. [img]/w3timages/icons/nuts.gif[/img]
    (And we have a 512K connection...)

  9. #9
    ruaridh_o'likely
    Guest

    Re: Disable non-existant macro in Excel 2000

    Just a couple of quick things:
    1. Did you double-click on ThisWorkbook? (You need to to open its code sheet)
    2. Have you done the same thing with each worksheet?
    3. Is it small enough to attach so we can look at it?

  10. #10
    Star Lounger
    Join Date
    Jan 2001
    Location
    The Land of Pleasant Living, Maryland, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    That's a WINNER!
    I copied the 2 sheets into a new workbook and except for some minor editing (when page 2 referred to a cell on page 1 the conversion insisted on including the link to the old file - which I removed manually) it now works as it should.

    Thanks a bunch - this was my first experience with Woody's Lounge (I read about it in his newsletter) and I'm impressed. As someone once said, :I'll be back!"

    Get well and thanks again.

    Peace,
    Tony

  11. #11
    Star Lounger
    Join Date
    Jan 2001
    Location
    The Land of Pleasant Living, Maryland, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    Thanks for the reply - but Leif solved the problem.

    Peace,
    Tony

  12. #12
    ruaridh_o'likely
    Guest

    Re: Disable non-existant macro in Excel 2000

    I figured he had (usually does[img]/w3timages/icons/grin.gif[/img]) but thought I'd throw that in for future reference!

  13. #13
    Star Lounger
    Join Date
    Jan 2001
    Location
    The Land of Pleasant Living, Maryland, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disable non-existant macro in Excel 2000

    Actually, I tried your idea and found a few words of what looked like code header and footer when I double-clicked on page 1. I erased the text, saved the file and the problem went away!

    Two solutions in less than a day - what a great site.

    Thanks.

Posting Permissions

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