View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Disable running of SelectionChange macro when in another macro

1. temporarily dis-able event macro
2. do your thing
3. re-enable event macros:


Sub MyMarco()
Application.EnableEvents = False
'
' do your thing
'
Application.EnableEvents = True
End Sub

--
Gary''s Student - gsnu201001


"Tonso" wrote:

In any event, I would still be interested in learning how to Not
invoke the SelectonChange macro if desired.
.