View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Disabling Sheet Code

Stuart,

You can disable event processing with

Application.EnableEvents = False
' your code here
Application.EnableEvents = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com


"Stuart" wrote in message
...
How do I disable Sheet code such as "Private Sub
Worksheet_SelectionChange(ByVal Target As Excel.Range)" from working when
another sub in another module is operating on the sheet.