I produce a number of automated forms in Excel, using VB. These are used by people of, err, well, let's just say, variable levels of computer literacy. This causes problems when they miss the "macros are disabled" warning, or are scared off by the warnings about dangerous content and I get irate messages about how my files don't work.
I'd like to set up a digital signature, probably using selfcert and get all logins on all PCs on our network set to Disable all macros except digitally signed macros and Automatically trust Stemar's macros, which I believe will solve the problems.
But
I'm not part of our IT department and their default position on anything like this is usually, "It can't be done." I have sponsors who are high enough that they can make it happen if I can prove "It can't be done" to be incorrect. So, here are my questions:
1. Will a home brew signature from selfcert work across a big network (2000+ PCs)?
2. Can access to this certificate be controlled so a list of no more than half a dozen users can access it to sign their projects?
3. IT currently does security & version updates remotely and in bulk. Would they be able to change settings in the Security Centre the same way?
Thanks for your help
I'd like to set up a digital signature, probably using selfcert and get all logins on all PCs on our network set to Disable all macros except digitally signed macros and Automatically trust Stemar's macros, which I believe will solve the problems.
But
I'm not part of our IT department and their default position on anything like this is usually, "It can't be done." I have sponsors who are high enough that they can make it happen if I can prove "It can't be done" to be incorrect. So, here are my questions:
1. Will a home brew signature from selfcert work across a big network (2000+ PCs)?
2. Can access to this certificate be controlled so a list of no more than half a dozen users can access it to sign their projects?
3. IT currently does security & version updates remotely and in bulk. Would they be able to change settings in the Security Centre the same way?
Thanks for your help