Hello Mari, To add to the other comments, there is an alternative: Get a code signing certificate from a trusted authority and sign your VBA project. Default trust settings in Excel allow signed code (with a trusted authority) to run.
You can verify what trust settings the client uses to ensure this would work. Asa -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mari Krishnamoorthi K Sent: Tuesday, February 28, 2012 12:10 PM To: MS EXCEL AND VBA MACROS Cc: mariseka...@hotmail.com Subject: $$Excel-Macros$$ Suppress the Disable Macros / Enable Macros Dialog. Hi Friends, As we are working in a customer provided citrix server, I could not change the macro security settings to Low. Is there any other way (VBA Coding) to suppress the disable / enable macros dialog box while the macro containing excel workbook. It would be better if any vba coding is there to force the user to hit enable macros. As this is requiring for an MIS WFM works. Swift reply will be expected. With Thanks and regards, Mari Krishnamoorthi. K marikrishnamoor...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
