 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2007Signing a macro
I have a macro I use for a spreadsheet and every time I open the workbook, it gives the warning about it being disabled because my security is too high. I want to keep my security high, for macros I use that I did not write. So how can I set it up to avoid that? How can I "sign" it or whatever it takes? TIA Steven http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=194  SignatureTim Williams Palo Alto, CA > I have a macro I use for a spreadsheet and every time I open the workbook, > it gives the warning about it being disabled because my security is too [quoted text clipped - 5 lines] > > Steven you can create a certificate of your own, look in the office programs folder then find "selfcert.exe" follow the steps to create your certificate, then in your macro editor, select the digital signature from the tools menu Signature-- --- ZZ [underground] Semi-musico,cuasi-poeta y loco >I have a macro I use for a spreadsheet and every time I open the workbook, >it gives the warning about it being disabled because my security is too [quoted text clipped - 5 lines] > > Steven Keep security at Medium. You are still asked whether to enable macros in the workbook, so something cannot run without your approval. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ >I have a macro I use for a spreadsheet and every time I open the workbook, >it gives the warning about it being disabled because my security is too [quoted text clipped - 5 lines] > > Steven |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.