View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
 
Posts: 486
Default 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.