Macro security in Excel 2007

J

jodleren

We have just moved to Office 2007, from teh good old office 2003 I
guess....

We have a large number of excel applications, for every day use.
In Excel 2000 and before, in the old Menu, I would go to Tool -
Options and find the Security tab with the Macro Security button and
set it to Medium. The advantage was, that our scripts work, users get
prompted so we can avoid crap etc.

Now, in 2007 - I have not found anything bye the options Disable all
or enable all.
Most of our apps uses a form with some buttons on it, expecting some
code/text in a field. It works well.
But, with the default setting 2 of 3 buttons in average do not work.
So far I have enabled all, but that is a security leak -
Of the option, digitally signed, that is not good either, as viruses
and bad stuff can have that too.

Any suggestions?

BTW is there a way to use "classic menus"? Like Classic windows?

WBR
Sonnich
 
B

Bob Umlas

Office button/Excel Options/Trust Center, click button "Trust Center
settings", then Macro settings section. Here's where your choices are!
 

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