Thread: Use checkbox to toggle between formula and manual input
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Use checkbox to toggle between formula and manual input

-----Original Message-----
pac,
....

Anyway, use

Application.EnableEvents = False
'other code
Application.EnableEvents = True

Beautiful!

Thanks Bernie.
Reply With QuoteReply With Quote