Remove opening dialog box
 

Hello,
I have removed all the macros in my Excel file. How do I stop the message
that asks you to either enable or disable the macros when the file is opened?

Thanks,
Ellen

Remove opening dialog box
 

You can stop that question by clicking Tools/Options on Excel's menu bar,
selecting the Security tab on the dialog box that appears, click the Macro
Security button at the bottom of the panel, select the Security Level tab on
the next dialog box that appears and, finally, clicking the Low option
button... but read the warning description attached to this option
carefully.

Rick

"EllenM" wrote in message
...
Hello,
I have removed all the macros in my Excel file. How do I stop the message
that asks you to either enable or disable the macros when the file is
opened?

Thanks,
Ellen

Remove opening dialog box
 

Have you tried also removing the modules that these macros were formerly in?
Choose Tools Macros Visual Basic Editor. The files you have open should
be listed in the upper left pane of the Visual Basic Editor. If they aren't,
try View Project Explorer. You may have to expand the file you're
interested in to see its modules. Then right-click the module(s) and choose
Remove Module...

It will ask you if you wish to export it before removing. If it's empty you
will say No.

I'm not 100% sure this will prevent the message you're getting, but it's the
first thing I'd try.

Keith

"EllenM" wrote:

Hello,
I have removed all the macros in my Excel file. How do I stop the message
that asks you to either enable or disable the macros when the file is opened?

Thanks,
Ellen

Remove opening dialog box
 

Thanks, Rick. I'm sure you solution works, but the Low option doesn't take.
I'm sure IT disabled it.

Thanks,
Ellen

"Rick Rothstein (MVP - VB)" wrote:

You can stop that question by clicking Tools/Options on Excel's menu bar,
selecting the Security tab on the dialog box that appears, click the Macro
Security button at the bottom of the panel, select the Security Level tab on
the next dialog box that appears and, finally, clicking the Low option
button... but read the warning description attached to this option
carefully.

Rick

"EllenM" wrote in message
...
Hello,
I have removed all the macros in my Excel file. How do I stop the message
that asks you to either enable or disable the macros when the file is
opened?

Thanks,
Ellen

Remove opening dialog box
 

Thanks Keith. Y'all are to quick to respond!!

"Keithlo" wrote:

Have you tried also removing the modules that these macros were formerly in?
Choose Tools Macros Visual Basic Editor. The files you have open should
be listed in the upper left pane of the Visual Basic Editor. If they aren't,
try View Project Explorer. You may have to expand the file you're
interested in to see its modules. Then right-click the module(s) and choose
Remove Module...

It will ask you if you wish to export it before removing. If it's empty you
will say No.

I'm not 100% sure this will prevent the message you're getting, but it's the
first thing I'd try.

Keith

"EllenM" wrote:

Hello,
I have removed all the macros in my Excel file. How do I stop the message
that asks you to either enable or disable the macros when the file is opened?

Thanks,
Ellen

Remove opening dialog box
 

Thanks, Rick. I'm sure you solution works, but the Low option
doesn't take. I'm sure IT disabled it.

That would make sense... they are trying to protect you from yourself.<g

Rick

Remove opening dialog box
 

Besides deleting macros, have you removed all modules (normal, class &
userform) and all code in any sheet modules or the ThisWorkbook module (if
there ever was any code in these).

Regards,
Peter T


"EllenM" wrote in message
...
Thanks, Rick. I'm sure you solution works, but the Low option doesn't
take.
I'm sure IT disabled it.

Thanks,
Ellen

"Rick Rothstein (MVP - VB)" wrote:

You can stop that question by clicking Tools/Options on Excel's menu
bar,
selecting the Security tab on the dialog box that appears, click the
Macro
Security button at the bottom of the panel, select the Security Level
tab on
the next dialog box that appears and, finally, clicking the Low option
button... but read the warning description attached to this option
carefully.

Rick

"EllenM" wrote in message
...
Hello,
I have removed all the macros in my Excel file. How do I stop the
message
that asks you to either enable or disable the macros when the file is
opened?

Thanks,
Ellen

Remove opening dialog box
 

Ah, I see similar was suggested a while ago by Keith, though it wasn't
visible to me when I posted.

Peter T

"Peter T" <peter_t@discussions wrote in message
...
Besides deleting macros, have you removed all modules (normal, class &
userform) and all code in any sheet modules or the ThisWorkbook module (if
there ever was any code in these).

Regards,
Peter T