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.
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.
Last edited by DonkeyOte; 01-12-2010 at 04:57 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
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.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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
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!
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks