Disable macros
Tech-Archive recommends: Fix windows errors by optimizing your registry
Date: Thu, 18 Nov 2004 10:49:08 -0500
Excel 2002, WinXP
I am opening a file with VBA and I want to open it with macros disabled. A
Google search of this subject gave me the following statement:
Application.AutomationSecurity = msoAutomationSecurityForceDisable
But this statement appears to be doing nothing about the macros in the file.
How would I use this statement, or another statement, if I want to open
MyFile.xls with macros disabled?
Thanks for your help. Otto
Relevant Pages
- Re: Backdoor.berbew.p now totally paranoid
... It will show you what file is opening what port and is communicating to what site. ... If you are using WinME or WinXP, disable System Restore ...
(microsoft.public.security.virus) - Re: VBA causing "Excel has encountered a problem" message
... Ronald R. Dodge, Jr. ... VBA is still new to me. ... Have you tried opening up Excel only, set the security level to medium ...
(microsoft.public.excel.programming) - Re: Update links in Excel using VBA
... I'm sorry, I'm new to VBA... ... closing VBA. ... The opening ... "macropod" wrote: ...
(microsoft.public.office.developer.vba) - Opening an Access db within vba
... Can anyone tell me the best way of opening an Access db from within the vba ... non-protected Access file which opens the new db with correct user name and ... can anyone tell me if there is a way of knowing if the Shell ...
(microsoft.public.access.formscoding) - Re: VBA form Crashes Word on opening!
... If you've done a lot of editing of the VBA then it is likely that you are suffering from a touch of template bloat, which can cause seemingly random crashes even through there is nothing wrong with the code. ... Now, regarding the autoopen macro, I've tried both opening the form itself ... The file is actually on the web to download and it's working for some people, ...
(microsoft.public.word.vba.general) |
|
