Remove macros from spreadsheet

[Guest]

I copied a sheet from one Excel workbook to another. The previous workbook
contained macros. This one will not, but the "enable/disable macros?" prompt
comes up every time I open the workbook. When I look for the macro
(Tools/Macro/Macros, there are no macros listed. How can I fix it so the
"enable/disable macros" prompt does not appear? Thanks.

 

[Norman Jones]

Hi Jan,

You need to delete any empty modules.

See als Debra Dalgleish's notes at:

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