Quote:
I take it that it is important to retain the macro warnings.
There are two ways to do away with them.
1) Change the setting so excel stops checking for macros altogether.
2) Get your macros secruity signed.
I agree that capablity is important, in principle, as people generally don't expect they would be running a program in a genral-purpose language capable of doing all kind of nasty things when they just run a spreadsheet. Probably seting 'paranoia level' to medium and just click that 'enable macros' button every time we load a spreadsheet we know should be acceptable.
BTW, I am not familiar with this particular implementation of PKI security: how does one sign a set of macros; who is generating key pairs and distributing public ones, who is certifying authority - can our (that is, Doug's in this case) own organization be that, without much fuss? And will Excel prompt us whether we trust particular credentials, anyway?
_________________________
Dragi "Bonzi" Raos
Q#5196
MkII #080000376, 18GB green
MkIIa #040103247, 60GB blue