Removing macros from an Excel spreadsheet

[Ross Dentith]

I have an Excel spreadsheet which contains a macro and am trying to
create a simplified version of it without the macro.

I have tried to remove the macro and have resaved the file under a
different filename. My problem is that whenever I try to open the new
file (which no longer has the macro) I still get the "macro warning" box
appearing each time.

I have tried removing the macro in several ways:

i) Using Tools, Macro, Macros, Delete

and

ii) also using Alt-F11 to open the VB Editor and then selecting the
Module in the "projects" browser, right clicking and choosing the
"Remove Module" option (without exporting).

Neither method seems to work though, and I can't seem to stop the "macro
warning box" appearing. Obviously I could get around this by switching
off the warning option, but this would then affect all files containing
macros, which I don't want to do.

Any ideas/suggestions would be appreciated

Thanks,

Ross

 

[Edgar]

I think the Macro is probably held in a sheet called
Personal.xls as well as in the current spreadsheet.

If you click on Window and then Unhide you get a box up
with the personal.xls in it. Click ok and then when you
have the spreadsheet selected go to the macro menu and
delete it out from there.

 

[Don Guillett]

Remove the module

 

[Ross Dentith]

I have just tried that and I don't have a spreadsheet called
Personal.xls. When I click on "Window", the "Unhide.." option is greyed
out.

Thanks anyway.

Ross

 

[Ross Dentith]

How do I do this? I thought I already had, using the methods described below,
but it seems that "something" must still be there.

Ross

 

[pfsardella]

Ross,

I would right click each of the Microsoft Excel Objects and 'View
Code' to make sure that there is no code in either the worksheets or
workbook class modules.

See this link provided by Debra Dalgleish for a good description.

http://www.contextures.com/xlfaqMac.html#NoMacros

HTH
Paul

 

[Earl Kiosterud]

Edgar,

As Don said, "remove the module." If there are any modules in the Modules
folder, you'll get that message, even if there's no code in them.
Right-click them and trash them. No export.

 

[Ross Dentith]

Paul,

Many thanks for this - I followed the instructions on the link you provided. Although I had removed the module
itself, there was a line of code in one of the worksheets in the Objects folder.

It now works fine
Thanks once again (and also to everyone else who offered advice)

Ross