Set macro security level to 'low level' on opening a certain workbook.

A

andreashermle

Dear Experts:

On opening a certain workbook, I would like to get the macro security
level set to 'low level' (enable all macros) automatically (by VBA),
regardless of the fact that it may have been set to this low level
before.

How is this achieved?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
 
G

Gord Dibben

It is not achieved.

If it was, there would be no need for macro security.

Why not place that workbook into Trusted Locations(if running 2007 or later)

If the workbook is to be opened by a user on another computer you will have to
sign the workbook as a Trusted Publisher.

2003 or earlier versions would require that you digitally sign the workbook to
make it trusted.


Gord Dibben MS Excel MVP
 
A

andreashermle

It is not achieved.

If it was, there would be no need for macro security.

Why not place that workbook into Trusted Locations(if running 2007 or later)

If the workbook is to be opened by a user on another computer you will have to
sign the workbook as a Trusted Publisher.

2003 or earlier versions would require that you digitally sign the workbook to
make it trusted.

Gord Dibben     MS Excel MVP

Dear Gord,

thank you very much for the insight into this matter. I will heed your
advice.

Thank you very much for your great support.

Regards, Andreas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top