ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macros (https://www.excelbanter.com/excel-programming/320203-macros.html)

Brian

Macros
 
I have deleted all of the macros in a workbook, but the Enable/Disable macros
prompt still appears when opening the workbook. How do I remove that without
changing security settings?

Norman Jones

Macros
 
Hi Brian,

You need to delete the empty modules.

See also Debra Dalgleish's notes at:

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


---
Regards,
Norman



"Brian" wrote in message
...
I have deleted all of the macros in a workbook, but the Enable/Disable
macros
prompt still appears when opening the workbook. How do I remove that
without
changing security settings?




Gary Brown[_5_]

Macros
 
Brian,
You may also have Excel version 4 macros in a hidden worksheet.
HTH,
Gary Brown

"Brian" wrote:

I have deleted all of the macros in a workbook, but the Enable/Disable macros
prompt still appears when opening the workbook. How do I remove that without
changing security settings?



All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com