Message box for cell change
 

I have a fairly large spreadsheet in which I have protected certai
cells from being accidentially modified by the user by setting Data -
Validation - Custom - =. I have found that it would be much mor
beneficial if I could instead have a pop-up box when a user tried t
modify a certain cell asking for verification before allowing them t
modify the cell. Is there a way to specify certain cells to call
pop-up box when a user tries to modify them

--
Prometheu
-----------------------------------------------------------------------
Prometheus's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=46689

Message box for cell change
 

You might want to look at the worksheet selection change event.

Change $A$1 to your cell address
Or you can generalize it by looking at
target.row and/or target.column

If target.Address = "$A$1" then
'code for pop-up
Else ' alternate code
End If

Post back if you need actual code.
--
steveB

Remove "AYN" from email to respond
"Prometheus" wrote
in message ...

I have a fairly large spreadsheet in which I have protected certain
cells from being accidentially modified by the user by setting Data -
Validation - Custom - =. I have found that it would be much more
beneficial if I could instead have a pop-up box when a user tried to
modify a certain cell asking for verification before allowing them to
modify the cell. Is there a way to specify certain cells to call a
pop-up box when a user tries to modify them?


--
Prometheus
------------------------------------------------------------------------
Prometheus's Profile:
http://www.excelforum.com/member.php...o&userid=15697
View this thread: http://www.excelforum.com/showthread...hreadid=466894

Message box for cell change
 

Delayed reply, been busy lately :)

Actually, if you could post a few lines of sample code that would be
great, I've never worked with the worksheet selection change event.

Thanks.


--
Prometheus
------------------------------------------------------------------------
Prometheus's Profile: http://www.excelforum.com/member.php...o&userid=15697
View this thread: http://www.excelforum.com/showthread...hreadid=466894