Can anyone help me how can I protect my woorksheet so that

1 only users on name list can access

or

2 only user putting secret value into specific cell can gain access

tnks & r

VCFF,
Go to: SAVE AS, select TOOLS from the top right hand corner of the dialogue
box, then select GENERAL OPTIONS. From there you can password protect the
file so you can't open the file unless you have the password.

Tom


"vcff" wrote:

Can anyone help me how can I protect my woorksheet so that

1 only users on name list can access

or

2 only user putting secret value into specific cell can gain access

tnks & r

Tom, tnks for your help. What I need is some VBA code which was suggested by
CLR which I saw on his reply under Excel file access password on 9/22/2006.
Had copied the info as below:

As Dave said, you can't "really" make Excel so secure that at competent
person cannot get in, but you "can" make the trip in so confounding that
only a truely dedicated individual will go through all the necessaries to get
there.........thereby, "keeping the honest people out"....
You could incorporate things like: 1-workbook won't open unless macros are
enabled, 2- Pass word(s) are invoked, 3-Only users with name on a list can
access, 4- only user putting secret value into specific cell can gain access,
etc etc........

Vaya con Dios,
Chuck, CABGx3


"James A" wrote:

I have excel files that I am selling to clients. I have seen other excel
templates that have features that I need such as: 1) You cannot copy the text
from the screen 2) You need a password to access similar to registration of
new software 3) Allows a 30 day free access then it become unavailable. Does
excel itself have these features or do I need to buy some other software?
--
James A

I was refering to No 3 & 4 option in which is there a way to do that with
VBA code as I was interested in that. Pls . advice.



"Tom" wrote:

VCFF,
Go to: SAVE AS, select TOOLS from the top right hand corner of the dialogue
box, then select GENERAL OPTIONS. From there you can password protect the
file so you can't open the file unless you have the password.

Tom


"vcff" wrote:

Can anyone help me how can I protect my woorksheet so that

1 only users on name list can access

or

2 only user putting secret value into specific cell can gain access

tnks & r