Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing Macro (Office 97)

    hi everyone!
    why is it that when i remove all macro via the Tools/Macro/Macros and save the file, when i open it again, the message ...The workbook you are opening contains macro........ still there? My e-mail system doesn't allow macros, so i need to disable them completely.

    any ideas? rgds.

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

    Re: Removing Macro (Office 97)

    You must also delete the module(s) that contained the macros.

    Go to the Visual Basic editor (Alt-F11). On the left you should have the project explorer (if not, select it from the View menu).

    Find the workbook's project from the list displayed, expand it and expand the item called Modules. Delete all items below that by rightclicking them and choosing Remove.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    May 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Macro (Office 97)

    thank you a lot, sir. it works like wonder. i did go there before but did not know what to look for!

    now, i need to go check any posting that i could help. i doubt it, but hopefully, as my returning the favour. regards.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts

    Re: Removing Macro (Office 97)

    Some email systems I send files to don't allow EXE files (for obvous reasons).
    When I need to send one (e.g. a self-extracting zip file) I just change the file extension before attaching and ask the recipient to change it back after saving.
    Works a treat.
    Have you tried sending an Excel file with macros with a different extension? e.g ".XLX" ?

Posting Permissions

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