ExcelBanter

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

Jean WY

Deleting Excel Macros
 
A user started to create an Excel Macro and deleted the macro before
saving the file. Now, however, he still gets a prompt to
"Disable/Enable Macros" when he opens the file. How do I get rid of
this prompt?


Dave Peterson

Deleting Excel Macros
 
Debra Dalgleish has some instructions:
http://www.contextures.com/xlfaqMac.html#NoMacros

Jean WY wrote:

A user started to create an Excel Macro and deleted the macro before
saving the file. Now, however, he still gets a prompt to
"Disable/Enable Macros" when he opens the file. How do I get rid of
this prompt?


--

Dave Peterson

Michael Smith

Deleting Excel Macros
 
Macro Securiry is probably set too high, and still recognizing some junk
in Personal.XLS...so either make sure PERSONAL.XLS is clean, or goto
Tools, Options, Securiy, Macro Security, and change the security to one
step lower and see if it solves the prob

Good luck!
</mike



*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 12:09 AM.

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