First of all, it is not "easy" to disable this SECURITY FEATURE. The whole idea is to make is so that those EVIL people out there that get their kicks out of writing virus' and finding some method to get them spread as far as possible have made it difficult for the rest of us.
Microsoft is allowing the user to see that a file they're about to open has macros. Now, there ARE ways to sign the macro VBA project and then Excel CAN open it because it is "trusted". But the simplest way is to create a single sheet that says "You Must enable macros for this file to operate properly. Please exit and re-open the file and select "Enable macros". Then, hide all of the sheets except this one. Create a Worksheet_Open event (or auto_open macro) and unhide your other sheets and hide this one. You may need to protect the sheets so that the user cannot open them without the macro running. hope this helps, Paul ________________________________ From: karthikeyan <karthikeyansankar...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Sunday, October 18, 2009 1:48:42 AM Subject: $$Excel-Macros$$ Macro Help Hi All, I have create a macro and sent to others these people open that particular file excel says popups 'ENABLE / DISABLE macros' they clicked DISABLE macros so macros are not working. How can i avoid this Proplem? Anybody knows let me know. thanks karthik --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
