We have recently run out Office 2003 accross the company and have currently got marco security set to medium as a lot of workbooks contain in house developed macros.
We would like to change the security level to high for obvious reasons and have installed a x.509 certificate on every users pc ( used makecert) and trusted access to ourselves as publishers.
Now we need to digitally sign every macro in every workbook. Is there an easy way to do this that doesn't involve manually loading each workbook and manually sigining it?
Am concerned that if there isn't I'll still be doing them next year!
Any help greatly appreciated
We would like to change the security level to high for obvious reasons and have installed a x.509 certificate on every users pc ( used makecert) and trusted access to ourselves as publishers.
Now we need to digitally sign every macro in every workbook. Is there an easy way to do this that doesn't involve manually loading each workbook and manually sigining it?
Am concerned that if there isn't I'll still be doing them next year!
Any help greatly appreciated