You know those annoying Microsoft Office Macro Security Warnings? There is a way to make them disappear, at least for you. Here's the Steps. Find the Microsoft Office Tools folder generally under Start > All Programs > Microsoft Office > Microsoft Office Tools Select Digital Certificate for VBA Projects (if you don't have such a link see this article ) Fill out the form and name it "Whatever makes you happy" Open your Microsoft Office Application and Open Visual Basic Editor Navigate to the Macro that is causing you Warnings Go to Tools > Digital Signature and click Choose Highlight the Certificate you just created, e.g. "Whatever makes you happy" Restart the Microsoft Office Application This time when you get the security warning choose, "Always Trust this Publisher" No more messages!
One Idea A Day, What I Learned Today