ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Get Macro warning, but can't find Macro (https://www.excelbanter.com/excel-worksheet-functions/126923-get-macro-warning-but-cant-find-macro.html)

Stilla

Get Macro warning, but can't find Macro
 
thanks in advance for your help..

I was working on a file, and must have added a macro inadvertently when I wa
experimenting with form controls.

the next time I opened the file, I got the macro warning, so I clicked
"enable," then found the one macro listed in the macro list under "this
workbook" and deleted it. I saved the workbook...even closed Excel, but I
still get the warning every time I open the file, and there is no macro in
the macro list...

I'm confused.... where is this thing hiding? I'm using Excel 2003..

It's important that I get rid of this warning because I need to send this
off to someone, and it can't have any warnings come up..

Thanks

Stilla

NEVER MIND! GOT IT... Get Macro warning, but can't find Macro
 
OK, sorry for the bother, I got it! Opened VBA editor...and even though I
could see no code, apparently there's still a module there that needed to be
deleted.. Now I know what to do the next time!

"Stilla" wrote:

thanks in advance for your help..

I was working on a file, and must have added a macro inadvertently when I wa
experimenting with form controls.

the next time I opened the file, I got the macro warning, so I clicked
"enable," then found the one macro listed in the macro list under "this
workbook" and deleted it. I saved the workbook...even closed Excel, but I
still get the warning every time I open the file, and there is no macro in
the macro list...

I'm confused.... where is this thing hiding? I'm using Excel 2003..

It's important that I get rid of this warning because I need to send this
off to someone, and it can't have any warnings come up..

Thanks



All times are GMT +1. The time now is 07:01 AM.

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