Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macros Word

Status
Not open for further replies.

naturalsn

Technical User
Apr 26, 2007
68
GB
Good Day

I currently have 2 Userforms that activate via a macro when selecting a specific Text From Field within my Word Document.

I recently emailed the document to another user but the user could not access these macros when they are suppose to activate, due to her macro security level within word set to High. I then changed it to medium wich then allowed the macros to run without any problem. My Problem is, I will be sending this document to several users and will not know what their macro security settings will be.And will not know how to change it. I know it is there for security reasons, but Is there a possibility to allow these macros to run, without the user having to do anything.

I would really appreciate any help or advise.

Thanks in advance.
 
hi
me again!! i think you might have missed the point of my post in the office forum that if users have the security set to high there isn't anything you can do about it - macros will not run!!

;-)
If a man says something and there are no women there to hear him, is he still wrong? [ponder]
How do I get the best answers?
 
Hi naturalsn.

Yes. Please read the replies you get clearly. Loomah did state that this should be a VBA post BUT...

then your questioned was answered. Making a copied post here in the VBA forum does not change the answer.

The answer is - NO.

Having siomething that by-passes it would completely neagte the point to having a security setting.

The answer is NO. There is nothing you can do to make no user action possible. Which is a good thing, as again, if you could, it would mean the security setting is meaningless.

The best you can do is have your document ask the user to close the document and manually set their security to Medium, and re-open it. However, this is a flawed process, as:

1. The user may...or may not.
2. The user may forget to put security back to High.

This is the way it is. So here is the answer again to your question:
Is there a possibility to allow these macros to run, without the user having to do anything
No.

Gerry
My paintings and sculpture
 
naturalsn,

You asked for help or advise, and have gotten a lot of advise, all of it 100% valid - there is nothing at all you can do to change someone else's security settings. See if the following constitutes help.

What you can do when you send this macro out is to include instructions that explain how to change the security setting, and let people know that the program will not run unless they do. I do this with all of the stuff I send out for others to use, and have had only one problem, ever - from a guy who admitted he hadn't bothered to really read the instructions in my e-mail.

If you give proper instructions and users don't follow them, you have done all you can.
 
Thank you very much for all the advise.
I Will be forwarding instructions with the document.

Thank you all again
SN

 
Make sure to remind them to put the security setting BACK, if they changed it.

Network people, and security weenies do not like users changing security levels...which is understandable.

Therefore if you are going to (in effect) instruct people to change security levels, cover your ass as best as possible. Not only give instructions to put it back, but give a direct message to do so. Perhaps when they close the document.
Code:
Sub Document_Close()
   Msgbox "Please ensure you return your Security Level to the previous setting!"
End Sub

Gerry
My paintings and sculpture
 
Gerry,

Good point. Seems I still have a problem with presuming others will see and do the obvious (to me) without my actually mentioning it. I'll have to keep that thought at the top of my mind when posting here.

I have what amounts to a "canned" set of instructions that go out with my macros/documents, along with the item-specific stuff. This standard verbiage contains instructions on how to set security to "Medium" in order to run the macros, and an exhortation to return security to "High" when done, if that was the original setting. The macros end with a closing routine very similar to yours (same thought, different wording).

Thanks for keeping me on track!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top