macro protection

J

Jacob Skaria

May be you can ask for a password within the macro...

I assume you know how to protect VBE..

If this post helps click Yes
 
L

Lois

I can protect the viewing of the macro, however i am wondering if i can
prohibit the RUNNING of it??
 
J

Jacob Skaria

1. You can get the user name using the below and then match it aganist a set
of users who need to use your macros. So within the macro you can 'End' the
procedure if the user is not valid.
strUserName = Environ("Username")

2. Within the macro itself (in the beiginning of the procedure) you can ask
the user to enter a password and validate whether the user is allowed to...


If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting Word 2019 document 0
Visio Diagram Protection 0
Protected Sheet - Using Groups without a Macro 1
Protected word template - vb/macro to update footer 7
macro Protection 1
Password protect new workbooks from template 0
Protecting Word 2013 file 1
Excel VBA Formula Help 4

Top