This might not be possible, but I figured I would ask anyways. I have an Excel workbook that runs calculations for our customers (they want Excel and not an EXE), and since the calculations are very long and tedious, they are only possible as macro functions.
I have used selfcert to create a digital certificate for the workbook, but I want to know if there is a way of creating a VB.Net application that can install the certificate automatically for the user.
Also related, is there a way of changing the macro security settings to allow only trusted certificates within Excel (since the default is to not trust any macros at all)? (This one I know is a long shot since it goes against the whole purpose of macro security, but it does not hurt to ask.) If not, is there a way of detecting the current security level so I can inform the user they need to change it?
I know you can bypass a lot of these problems by creating an Excel addin, but the macros are based on a specific workbook with specific sheets and data layouts. So an addin is not a solution in this scenario.
Thanks, Chris
Submit an article or tip