Actually,
I was hoping for an command line option Like:

c:\Program Files\Microsoft Office\Office\Excel.exe "My file.xls"
\disablemacros



"Jebaneesa" wrote:

Mauricio,

All you have to do is before you open any workbooks go to the tools menu,
select options and then select the security tab. From there you can change
the Macro security, depending on which version of Excel you are using you may
have to click another button called "Macro Security" to adjust the settings.

Hope this helps

Jebaneesa

"Fredrik Wahlgren" wrote:


"Mauricio Silva" wrote in message
...

How do I open a spreadsheet with macros disabled already?

Reason: I am exporting data from Access to a pre-formated spreadsheet
(which
I cannot change). Every time I open the file, a screen asking
Enable/Disable
macros appears.

Is there an option to open the spreadsheet with them disabled already? I
know it is not an MS Access matter, it is just matter of knowing the right
option to do it.

Thanks

Mauricio Silva

Do you want the macros to be disabled without asking? I don't think so. I
mean, what if you suddenly want them to be enabled, how should that be done?

/fredrik