set macro security level through VBA

G

Guest

Friends,

Is there a way to set the Tools\Macro\Security level (Low, Medium, High)
through VBA code?

Thanks for your help ...
 
T

Tim Williams

Don't think it can be done in the same process. You might be able to
do it automating one instance of Excel from another. Not easy for all
the obvious reasons.

Tim
 
G

Guest

Thanks Tim ... you both saved me alot of time (not trying to do the
impossible) ....
 

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

Similar Threads

Set macro security level to 'low level' on opening a certain workbook. 2
Difficulty opening Access from within Excel 2
Need help creating VBA procedure for Open event 2
Return Excel's current security setting 2
Macro-Security level value 3
Can I run a parameterized macro with medium security? 2
Changing Macro Security settings does not work 1
Macro/Trust Center Settings 5

Top