Enable macros through email attachments

**dwarford101** · 01-12-2010, 05:21 AM

I have coded my spreadsheet to send a copy of my active spreadsheet to the email addresses which i have put into the code.

When the attachment comes through to the email addresses, The customer will open the attachment and will have to enable macros for the spreadsheet to work, What i want is for the customer to recieve the spreadsheet but not have to enable the macros, there must be something out there which will auto do this for them.

**DonkeyOte** · 01-12-2010, 05:27 AM

No - being able to automate Macro security would rather negate the purpose of the security would it not ?

A common approach to handling this is discussed: http://www.cpearson.com/excel/EnableMacros.aspx

Discussions on circumventing Security via Code are prohibited on this Forum.

**Leith Ross** · 01-12-2010, 05:31 AM

Hello dwarford101,

Unless the workbook is from a trusted source (digitally signed like VeriSign), the user will have to decide if they want to enable macros. This is by design for security against malware programs.

**dwarford101** · 01-12-2010, 05:53 AM

Thanks for your replys, I did know all this but i thought some genuis would have some kind of way roudn it, Oh well never mind worth a try

**royUK** · 01-12-2010, 08:30 AM

Your post does not comply with Rule 12 of our Forum RULES. Do not post questions with regard to breaking or bypassing a password of any type or post questions with regard to bypassing a users security settings, all such posts will be deleted, repeat offenders will be banned!