Macro Problems

[James]

Hello I am not too sure if I am posting in teh right place
but here goes...

Basically I have some macro's in my workbook and I now
downt need them do I deleted them and saved my workbook. I
then go into the workbook and it tells me there are macros
and if I wish to enable or disable them. This is becoming
a pain and I dont want that warning to go away.

How can I solve this problem?

Many Thanks

James

 

[Andy Brown]

James,

You need to dump the module(s) that housed the macro(s). See here -

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

Rgds,
Andy

 

[Frank Kabel]

Hi James
you also have to delete the (now empty) modules. Try the following
- open the VBA editor (ALT + F11)
- delete / remove the modules from your file/project
- also check the worksheet modules and the workbook module for code
- close the VBA editor
- save your workbook
- close and try again

 

[James]

Thanks alot to you both... it works a treat!!

James