Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Carolina Lopez   on Nov 08 In MS Office Category.

  
Question Answered By: Charlotte Brown   on Nov 08

I'm not a fan of suppressing events. I'd much rather ignore them. So,
simply ...

sub my event
if not NestedCall then
NestedCall = true
... all the good stuff
NestedCall = false
end if
end sub

NestedCall is a simple  Boolean variable defined at the module level. You
can take advantage of the fact that Excel will initialise it to false  for
you.

Share: 

 

This Question has 8 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Want to disable a Checkbox_click event Or get search suggestion and latest updates.


Tagged: