Requiring a cell password

D

Duncan, UK

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.
 
F

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
Click to expand...
created by a formula exceeds a certain preset value.
Also can I use validation rules or something else that
Click to expand...
requires users to enter a value or text into a cell?
 
D

Duncan, UK

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.
 
Top