Assign the tickbox to a third macro...

Sub Third
if tickbox.value = true then
smallmacro1
else
smallmacro2
end if
End Sub
--
Jim Cone
Portland, Oregon USA



"Ken G."
wrote in message
I have two small macros that I want to assign to a tick box. I know how to
assign one macro, but can I assign two so that when the box is ticked it runs
one macro and when its unticked it runs the other?