Requiring a cell password

[Guest]

I require a password to be entered if a cell value created by a formula exceeds a certain preset value.
Also can I use validation rules or something else that requires users to enter a value or text into a cell?
Thanks.

 

[Frank Kabel]

Hi
in general possible. (using either worksheet_change or
worksheet_claculate events). But you may provide some more
details.
- the formula you are suing
- what should happen if the user does not have the
password?


For the validation rules have a look at 'Data - Validation'

-----Original Message-----
I require a password to be entered if a cell value

created by a formula exceeds a certain preset value.

Also can I use validation rules or something else that

requires users to enter a value or text into a cell?

 

[Guest]

The spreadsheet is a quotation total and users are not allowed to issue quotes over a certain value eg 10K. So the formula in the cell is just a total eg =SUM(G59:G90) and if the value is over the 10K then they have to ask a supervisor who will have the password to approve the quote.
Also there is a text cell (customer categories) that I want users to be forced to enter a value in from a drop down box that I have created from the validation function.
Thanks.