Creating a digital signature for my VBA code which will be valid for our domain.
Posted on 2011-03-25
I've no idea if this is possible or how to achieve it.
I create Excel spreadsheets with VBA code. Primarily these are pivot style db maintenance. A recent project involves a sheet with (currently) just over 82,000 cells. The table contains a priority level between suppliers (the Y axis - rows) and customers (the X axis - columns).
There is event code behind the scenes dealing with sync changes to the DB and to correctly colour the cell as they change the value (just a single digit).
Using a spreadsheet is significantly easier for this size of data for the users. Initially they had a web app which only allows 25 suppliers on a page at once and scrolled the entire page left/right to get the different customers. A shrink wrapped app I'm rewriting. So far, so good.
One of the issues I have is that I need to sign the vba code so that the users can load the file. I use Office 2003. Different users are on 2003, 2007 and 2010.
We all operate within a domain and have Active Directory and Group Policies.
When a user loads the spreadsheet, they have to jump through several hoops to allow the macros to run. On 2003, this is fairly simple. I'm completely lost on 2010 (I don't even know how to move around the app as there is no menu - but that's another issue for me).
What I want to achieve is a way that I can sign the VBA code and all the users automatically trust it. No popups or anything. Just as if the spreadsheet had no VBA code in it at all.
Whatever I do, I'll be passing the actual work to our sysops (they are looking into this as well, but neither of us are familiar with this).
I don't mind what work I have to do as long as I don't need to visit every user and manually allow the code to run.