Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XLM marco (Excel 97 SR2)

    Excel 97 tells me my spreadsheet contains macros and that they can't be disabled because they are Excel 4 macros. I know the macros are harmless but for the life of me I can't find where they are hiding in order to remove them.

    <img src=/S/confused.gif border=0 alt=confused width=15 height=20> stuck

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLM marco (Excel 97 SR2)

    Excel 4 macros were usually contained in macro sheets. Maybe they are hidden. See if you can find some hidden sheets. Otherwise, they may be contained in a general module (however, I am not sure of this, as I have never tried to run Excel4 macros since the start of VBA in Excel 5). If so, you should go to the VBE (Visual Basic Editor) and remove the general module.

  3. #3
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLM marco (Excel 97 SR2)

    I don't think you can see excel 4 macro sheets in the VBE - I would go for your first suggestion of hidden sheets and if that doesn't work I'd then tear my hair out.


    Brooke

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

    Re: XLM marco (Excel 97 SR2)

    They may also be hidden in Defined Names. E.g. when the sheet once has been used to get some external data, hidden names are created with XL4 macro commands in them. Also some names you define yourself can cause XL to think they are XLM style.
    Lastly sometimes a button on a dialog (xl5 style userform) that has a maccro attached may cause this to happen.

    Good hunting!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLM marco (Excel 97 SR2)

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    stuck

  6. #6
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLM marco (Excel 97 SR2)

    Thanks everybody.

    Jan's ideas look promising but Han's and Brooke's suggestions have left me bald! (There are no hidden sheets and the only VB module I can find holds some simple macros recorded in XL97 to sort selected rows.)

    Can you give further hints on the sort of names that may cause XL to think they are XLM style? My sheet includes several names that involve OFFSET functions to dynamically range charts. Also I have buttons on several pages that run the sort macros mentioned above.

    stuck

  7. #7
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLM marco (Excel 97 SR2)

    Does it help just to copy the sheets to a new spreadsheet, and to save that worksheet under a new name?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  8. #8
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLM marco (Excel 97 SR2)

    <P ID="edit" class=small>Edited by WebGenii on 08-Sep-01 16:10.</P>I had a similar situation <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=63142&Search= true&Forum=All_Forums&Words=jujuraf&Match=Username &Searchpage=1&Limit=25&Old=allposts&Main=62911>(se e post 63142)</A> and I finally discovered that these XLM macros appeared if I did right-click on some object (one done in the drawing tool) and then 'assign macro'. This is okay but I could never remove these things and then xl97 would complain. I contacted MS and they agreed it was a bug and that the old macros are still stuck in Excel and can't be removed. They recommended rebuilding (of course, I've had to do that several times now). I no longer ever use the right-click 'assign macros' only use the ActiveX controls on my sheets. These XLM were not in my code that I could find and I even used VBA to list them but it came up empty as well. When I say xl97 complained, I mean that if I launched the workbook and disabled macros, I got an error message about those old style macros so I then knew they were in there (xl2000 didn't give me this message).

    Deb <img src=/S/flags/California.gif border=0 alt=California width=30 height=18>

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

    Re: XLM marco (Excel 97 SR2)

    I tend to keep using the form objects that require "assign macro's" and do give the xlm warning (which only appears when you ask to disable macro's...), because those controls are much more reliable and simpler to use.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: XLM marco (Excel 97 SR2)

    I guess if they work for you, that's what counts. I find the ActiveX controls much easier to use as they have more features. All the books I have read recommend them over the old style, but if you can get by with them, that's great. I'd be interested in hearing what you have come across that makes you suspicious of the newer ActiveX controls in that you said they're less "reliable."

    Deb

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

    Re: XLM marco (Excel 97 SR2)

    For one, try setting their "take focus on click" to true (default!) and running a macro from them. Some macro actions fail (I tend to think copying was one of them).
    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
  •