VB-excel-macro help

Questions on PC Repair, Modding Upgrading and more

VB-excel-macro help

Postby alien » Sat Aug 21, 2010 3:43 am

Please tell me if there a solution for the following requirement.

I need a macro (excel) which can change security of the macro (tools>Macro>security>) to Low & High by it self. Running macro will change the security option. Even though your security is set to High this will runs and change it to Low, i.e.

1) macros hard to (not impossible) run when it set to high.
2) but most of Excel options can change/lock/ fix with macros Eg. Can stop "save as function" or limiting other menu options

Asking this Q on behalf of a friend. Looking forward to hear from you guys. Thanks!
somebody had to say it, I don't know why it has to be me?
User avatar
Posts: 1682
Joined: Thu Nov 12, 2009 7:20 am
Location: KL, Malaysia
Has thanked: 12 time
Have thanks: 38 time

Return to Help Me Fix

Who is online

Users browsing this forum: No registered users and 1 guest