Hi Karthikeyan,
Greetings!
Please follow the below steps to avoid the Enable/Disable macros :
1. Look in C:\Program Files\Microsoft Office\Office (or C:\Program
Files\Microsoft Office\Office10), and there should be a program called
selfcert.exe.
2. Run the selfcert.exe program (just double click it). Type in your name in
the "Your Name" box, and then press OK. It will say it has successfully created
a certificate. Press OK to that.
3. OPen Excel. If it gives you a security warning about macros, click "enable
macros", ticking the "always trust macros from this source" box.
4. In Excel, go to Tools/Macro/Visual Basic.
5. Choose Tools/Digital Signature, and then click Choose to sign your project
with ‘your name’ certificate.
6. Save the project, exit Visual Basic, exit Excel (if it asks if you want to
save the code, say yes).
7. Restart Excel. It will ask if you want to trust the certificate. Click the
"don't ask this again" box, and then click yes.
Next when you will open the excel file , it will not show any warning....
Let us know if above steps helps or not.
Thanks and best regards,
Ayush Jain
--- On Sun, 18/10/09, karthikeyan <karthikeyansankar...@gmail.com> wrote:
From: karthikeyan <karthikeyansankar...@gmail.com>
Subject: $$Excel-Macros$$ Macro Help
To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com>
Date: Sunday, 18 October, 2009, 11:18 AM
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
Add whatever you love to the Yahoo! India homepage. Try now!
http://in.yahoo.com/trynew
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
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
-~----------~----~----~----~------~----~------~--~---
