Excel macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bertie - 13 Sep 2007 08:06 GMT

I have deleted all macros from an Excel workbook, but when I open the
workbook I still get the security message about enabling/disabling the macros.

Signature

Bertie C

Reply to this Message

Joel - 13 Sep 2007 09:14 GMT

1) Make sure there isn't any macros in ThisWorkbook or any of the sheets.
2) Remove the modules. In VBA Projects Window right click each module and
select remove.

> I have deleted all macros from an Excel workbook, but when I open the
> workbook I still get the security message about enabling/disabling the macros.

Reply to this Message

Bob Phillips - 13 Sep 2007 09:30 GMT

See http://www.contextures.com/xlfaqMac.html£NoMacros

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have deleted all macros from an Excel workbook, but when I open the
> workbook I still get the security message about enabling/disabling the
> macros.

Reply to this Message