How to open a spreadsheet with Macros disabled
 

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

"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

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

Either set macro security to "High" or hold down the SHIFT key while the book
is opening.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 11:13:04 -0800, "Mauricio Silva"
wrote:


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

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Either set macro security to "High" or hold down the SHIFT key while the
book
is opening.



Isn't the macro security a global setting? If so, that would affect other
sheets which the user wants to open with macros enabled.

/Fredrik

Correct.

It would affect all workbooks with macros.

But can be used as a temporary method to get into the one workbook without
macros being enabled.

When done with this workbook, reset the security level.

To quote Abe Lincoln "you can't please all the people all the time"


Gord

On Wed, 23 Mar 2005 22:07:43 +0100, "Fredrik Wahlgren"
wrote:


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Either set macro security to "High" or hold down the SHIFT key while the
book
is opening.



Isn't the macro security a global setting? If so, that would affect other
sheets which the user wants to open with macros enabled.

/Fredrik

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