• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatically enable macro

W

webmax

Member
Hi,

I have a macro file if i send to other person it is showing the security alert to enable the macro. can any one guide the macro code it would automatically enable the macro if the other person open the excel file.
 
Hi Shahul ,

This is not possible , since a macro can run and perform some action only if the security settings on the user's computer allow the macro to run ; if the security settings do not allow the macro to execute , it is impossible for the macro to enable that setting.

What you can do is to use a splash screen to warn the user to enable macros ; if the user does not do so , all the useful sheets of the workbook can remain hidden and the file itself not of much use , though if the user is determined enough , probably this security of yours can be cracked.

Narayan
 
I know it's a pita. If I had a dollar every time I got a phone call like:

Person: "YOUR MACRO DOESN"T WORK"
Me: "What's it doing?"
Person: "NOTHING THATS THE PROBLEM"
Me: "Did you enable macros?"

I'd be rich.
 
You must log in or register to reply here.
Back
Top