Macro security in Excel 2007
 

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

Macro security in Excel 2007
 

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


"jodleren" wrote in message
...
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