Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dialog box upon opening workbook | Excel Worksheet Functions | |||
Opening Excel - getting print dialog box | Excel Discussion (Misc queries) | |||
Opening the Autofilter dialog box | Excel Programming | |||
Opening a dialog | Excel Programming | |||
Opening a new mail dialog box in Excel using vba | Excel Programming |