I have a workbook on our file server that our company has started using emphatically. My problem is I don't have a digital signature and many times someone will open it up and not see the security warning and so they won't enable the macros and therefore the calculations don't work. If they enable them it all works great.
What I'd like to do is somehow force them to enable macros with a message of some kind or if I can change the security warning to be a different color say red. Then it would be easier to see. Any thoughts? I know getting a digital cert would probably be easier but it's not in the budget right now and I don't understand it well enough to convence them to put it in the budget.