Why show Enable/Disable macro prompt after I deleted all macros?
Hi,
I used to have some macros in my excel which I deleted. Now I still get the Enable/disable macro prompt and the Personal workbook (where the macros were) keep opening- it's irritating, how do i stop both?. I want to keep my security settings as it is. Thanks |
Why show Enable/Disable macro prompt after I deleted all macros?
You probably still have a module or modules in the VB Editor.
Go to the VB editor and right click on any modules and select delete, when asked if you want to export data, select no. HTH Regards, Howard "m123" wrote in message ... Hi, I used to have some macros in my excel which I deleted. Now I still get the Enable/disable macro prompt and the Personal workbook (where the macros were) keep opening- it's irritating, how do i stop both?. I want to keep my security settings as it is. Thanks |
All times are GMT +1. The time now is 11:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com