Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 - Getting enable macro prompt with no macros in spreads | Excel Programming | |||
How do I have excel not to prompt user to disable or enable a micro | Excel Programming | |||
Prompt to enable/disable macros | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
Enable Macros with No Prompt | Excel Programming |