Excel- password Data Validation 1

[MrsTFB]

I want to set a data validation on a cell that another user can't just change by removing the validation.

Is there a way to password the particular cells, or place some sort of restraint greater than the validation?

Thanks in advance :-s

bsimm

 

[JrClown]

bsimm,
One way of doing this is as follows:
Click on
Data, then
Validation
Under Settings you can choose how to restrict individual cells, good luck and let me know

 

[MrsTFB]

Hi,
I should have told you it was Excel97. That's probably why my Data Validation doesn't seem to have a choice for settings.
Unless I'm missing it. I could be.

I have a few users of the worksheet that would be just #*&$*# enough to change the validation and enter what they wanted anyway. I need to find a way to stop this.

Thanks for your help

Bsimm B-) Go TITANS!

 

[JrClown]

bsimm, if you click on Data then Validation you should be able to see what I'm talking about.


Tonight my Redskins will be :-9 and LOL when we crush your Titans.

 

[MrsTFB]

Well JrClown,
I went back to the Excel and I don't have a properties anywhere. I have Data--Validation--Settings. This is where you set them to Custom or length of cell, etc. I have done that with an error message that tells the user, data may not be entered there. You must go through the program, which requires a password. It will then place the data in the cell through the macro. What I am wanting is to fix it that the user can't just go in and change the validation, enter the data, and change the validation back.
Is that where the Properties come in?
Do you think I have missed part of my Excel97 installation. Could it be an add-in?

So Sorry about your 'Skins

Hope you will help me anyway. ;-)

Bsimm

 

[JrClown]

Well "Sorry Titan's that were given the game away" fan, I'm not sure, why you don't have those options. Perhaps you should try re-installing the programm
%-(

 

[MrsTFB]

I have been scatterbrained with this post. I do have settings. For some reason I thought you had written Properties, was looking for that.

I can set the Settings. I set them to Custom and type ASDF. Then the error message tells the user that data must be entered by using the Password program.

I just didn't want anyone else to be able to change my Custom back to Any Value and type what they wanted. I don't really think you can do that though without protecting or passwording the entire workbook and I can't do that.

What did you mean by 'given the game away'? You guys didn't play that bad.

Thanks for your help

Bsimm :-s

 

[JrClown]

Why don't you set that cell to be a drop-down box and hide the reference in a different area of the sheet? I do that all the time. That way they only see what you want them to see.
About the game:
Turnovers hurt us, we played good enough to win, I feel better knowing that we lost that way than playing great and loosing by 30.

 

[MrsTFB]

Have never done that, but I'm going to play with it.

Thank you soooo much for your ideas.

Bsimm

 

[JrClown]

If you need help with it bud, email me at
Jr_Clown@yahoo.com
I'll send you a sample of a drop-down box with listings.
Glad to help bro.
;-)