 |
 | 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 / Word / Programming / October 2006Expert help on security and vba code needed
I need to send out a word form with some vba code in it every 6 months to staff members to run on their home computer. My understanding is that they will have a problem with this form if their security settings is medium to high. Is there any way, other than asking them to set their setting to low, to allow this form to run the vba code? E.G., since they know where this form originated, is there a way for them to set their computer to accept and run the code in the form without having to set their security level to low every time they receive the form? Much thanks for any and all ideas, Mark Method 1: sign the code, and ask the users to accept your certificate. They'll need to do this only once. If you have the budget, you can buy a commerical software certificate. I have heard, but haven't tried this myself, that a personal email certificate (such as you can get for free from Thawte), will also work. Method 2 (if it's the same code each time): Put the code in an add-in, which the users install in their start-up folder. Use a document variable or some such in the form document itself, so the add-in can recognise the relevant documents. >I need to send out a word form with some vba code in it every 6 months to > staff members to run on their home computer. My understanding is that [quoted text clipped - 13 lines] > Much thanks for any and all ideas, > Mark Jezebel, You are a life saver. I was hoping this could be done. Many thanks, Mark > Method 1: sign the code, and ask the users to accept your certificate. > They'll need to do this only once. If you have the budget, you can buy a [quoted text clipped - 24 lines] > > Much thanks for any and all ideas, > > Mark If they have the security level set to Medium, they'll see a message box before the form opens, with buttons for Disable and Enable. If they click the Enable button, there won't be any problem with the macros. The only problem that some people might have is in trying to open the form on a work computer that has the security level forced to High by an administrative policy. That would mean that they can't change the level to anything else, and the macros would be disabled. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. >I need to send out a word form with some vba code in it every 6 months to >staff members to run on their home computer. My understanding is that they [quoted text clipped - 9 lines] >Much thanks for any and all ideas, >Mark Jay, Many thanks for your experience, Mark > If they have the security level set to Medium, they'll see a message > box before the form opens, with buttons for Disable and Enable. If [quoted text clipped - 26 lines] > >Much thanks for any and all ideas, > >Mark |
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.