Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open file macros inactive
I need to open a file read only and macros inactive.
I know how to do read only but how to do macros inactives? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open file macros inactive
Put this around your workbook open code
Application.AutomationSecurity = msoAutomationSecurityLow 'Workbook open code Application.AutomationSecurity = msoAutomationSecurityByUI HTH, Barb Reinhardt "Alberto Ast" wrote: I need to open a file read only and macros inactive. I know how to do read only but how to do macros inactives? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
open file macros inactive
Barb,
Wouldn't this affect my main file macros? I need to open the second file with macros inactive... will below do it and still keep my master file macros active. Please calrify. "Barb Reinhardt" wrote: Put this around your workbook open code Application.AutomationSecurity = msoAutomationSecurityLow 'Workbook open code Application.AutomationSecurity = msoAutomationSecurityByUI HTH, Barb Reinhardt "Alberto Ast" wrote: I need to open a file read only and macros inactive. I know how to do read only but how to do macros inactives? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
open file macros inactive
Really the right word I should have used for what I need is macro disable.
"Barb Reinhardt" wrote: Put this around your workbook open code Application.AutomationSecurity = msoAutomationSecurityLow 'Workbook open code Application.AutomationSecurity = msoAutomationSecurityByUI HTH, Barb Reinhardt "Alberto Ast" wrote: I need to open a file read only and macros inactive. I know how to do read only but how to do macros inactives? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
open file macros inactive
If you do this
Application.AutomationSecurity = msoAutomationSecurityForceDisable Your macros will stop altogether. Just try it and step through the code to see if it works. I guarantee it will. You won't get an enable macro message and any workbook open code that you have will not run. Isn't that what you want? "Alberto Ast" wrote: Really the right word I should have used for what I need is macro disable. "Barb Reinhardt" wrote: Put this around your workbook open code Application.AutomationSecurity = msoAutomationSecurityLow 'Workbook open code Application.AutomationSecurity = msoAutomationSecurityByUI HTH, Barb Reinhardt "Alberto Ast" wrote: I need to open a file read only and macros inactive. I know how to do read only but how to do macros inactives? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
open file macros inactive
Thanks Barb.. it did open with macros disable but my initial macro where I
open the file stop there after opening a file... it did not perform the rest of the macro... how do I enable it again so it will continue. Thanks, "Barb Reinhardt" wrote: If you do this Application.AutomationSecurity = msoAutomationSecurityForceDisable Your macros will stop altogether. Just try it and step through the code to see if it works. I guarantee it will. You won't get an enable macro message and any workbook open code that you have will not run. Isn't that what you want? "Alberto Ast" wrote: Really the right word I should have used for what I need is macro disable. "Barb Reinhardt" wrote: Put this around your workbook open code Application.AutomationSecurity = msoAutomationSecurityLow 'Workbook open code Application.AutomationSecurity = msoAutomationSecurityByUI HTH, Barb Reinhardt "Alberto Ast" wrote: I need to open a file read only and macros inactive. I know how to do read only but how to do macros inactives? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
open file macros inactive
I removed all the Application.Automa..... comand lines I previously posted so
for now the macro will finish all the way but it acts as if I had not removed the Applicaion.AutomationSecu..... command... it open the file and then stop... I have this Sub OpenFile() Workbooks.Open Filename:="MyFile.xls", ReadOnly:=True Workbooks("MyFile.xls").Close savechanges:=False Windows("File_with_original_macro.xls").Activate End Sub "Barb Reinhardt" wrote: If you do this Application.AutomationSecurity = msoAutomationSecurityForceDisable Your macros will stop altogether. Just try it and step through the code to see if it works. I guarantee it will. You won't get an enable macro message and any workbook open code that you have will not run. Isn't that what you want? "Alberto Ast" wrote: Really the right word I should have used for what I need is macro disable. "Barb Reinhardt" wrote: Put this around your workbook open code Application.AutomationSecurity = msoAutomationSecurityLow 'Workbook open code Application.AutomationSecurity = msoAutomationSecurityByUI HTH, Barb Reinhardt "Alberto Ast" wrote: I need to open a file read only and macros inactive. I know how to do read only but how to do macros inactives? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open file with macros | Excel Discussion (Misc queries) | |||
Not allow to open file it do not accept macros | Excel Programming | |||
Open file without macros | Excel Programming | |||
In VBA, Open a file with macros disabled | Excel Programming | |||
How can I have a macros automatically run when I open up the file. | Excel Programming |