Remove opening dialog box

[Guest]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Guest]

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

 

[Guest]

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

Thanks,
Ellen

 

[Guest]

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

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Peter T]

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

 

[Peter T]

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

Peter T