P
Prometheus
I have cells that reference VBA functions I've written. Right now the
are protected from users accidentally disturbing them by Data -
Validation -> Custom -> =. Now a situation has arisen where there wil
be a few instances where someone will need to manually enter data int
one of the protected cells. I would like to change it so that if
user tries to type something into a protected cell a yes/no box appear
asking if they really need to enter data into the cell. If they clic
'No' then they can't, if they click 'Yes' then they will have access t
the cell. Any idea how I might go about doing this?
Thanks
are protected from users accidentally disturbing them by Data -
Validation -> Custom -> =. Now a situation has arisen where there wil
be a few instances where someone will need to manually enter data int
one of the protected cells. I would like to change it so that if
user tries to type something into a protected cell a yes/no box appear
asking if they really need to enter data into the cell. If they clic
'No' then they can't, if they click 'Yes' then they will have access t
the cell. Any idea how I might go about doing this?
Thanks