It is my experience that creating the digital certificate is quite easy and the authority works as soon as you re-open the file. Thank you for additional information regards digital signatures. In answer to the last entry, when you open an Excel file that contains macros, you are confronted with a window whose text is 'Security Warning' and you are provided with 3 choices Disable Macros, Enable Macros and More Info.Īny help via a PM or email will be greatly appreciated. I hope that I have assured you of my integrity. Īs I can program a little in VB, it will be a relatively easy task to prevent any other users from utilizing the script, when the script is buried within an EXE that is in itself within another EXE.

Obviously, to prevent brain-dead idiots from viewing the script, I would expect it to be delivered in a Private Message or a direct email to me at. Can I say at the outset, if my intentions were not noble, this request could have been very easily been disguised with a different window and button text.Īs stated, my reason for this request is to force all users of a particular Excel file to be under total control of workbook macros, which is a perfectly legitimate reason for its use.Ī staggering number of users on the internet seem to have this problem and are seeking resolutions.

Automatically enable content excel vba