if ocontrol.value = true then
application.enableevents=false
'do your stuff
end if
application.enableevents=true

hth!
susan


On May 11, 12:18 pm, clara wrote:
Hi all,

How to disable a change event when a control is assigned a value.

Clara
--
thank you so much for your help