[SOLVED] making a checkbox appear and disappear based on a cell's value

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

Awesome. Many thanks Peter and Jim.

Awesome. Many thanks Peter and Jim.

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

Awesome. Many thanks Peter and Jim.