Hi,
Anyone know is it possible to bypass the security question that Microsoft Excel generates about "enabling macros" through VBA, when one trys to open an excel spreadsheet?
Thanks.
Printable View
Hi,
Anyone know is it possible to bypass the security question that Microsoft Excel generates about "enabling macros" through VBA, when one trys to open an excel spreadsheet?
Thanks.
You cannot change it via code (if you could, what would be the point of it? ;) ). To change it manually go to "Tools" -> "Macro" -> "Security".
You can also add a signature to your files (which tells Excel that you trust that particular publisher).. I think this is described in the FAQs at the top of this forum.