making a checkbox appear and disappear based on a cell's value
Sorry... Not in Thisworkbook, but rather in the sheet that is the target...
Also Peter has a better eye than I do. There is a typo in the procedure
name... Monday is getting the best of me here...
--
HTH...
Jim Thomlinson
"Jim Thomlinson" wrote:
Sorry about taking so long... The code that you posted needs to be in the
ThisWorkbook module, and events must be enabled. If it is in thisworkbook
then run this code to reset your events...
Sub test
Application.enableevents = true
end sub
You should also check for where it was set to false and ensure that that
code is working properly.
--
HTH...
Jim Thomlinson
"yoram" wrote:
Thanks for the prompt response. Unfortunately, the code still doesn't
work for me. Changing the cell's value doesn't make the checkbox
visibile/invisible. I am running 2002 and tried with protection on/off.
|