Many thanks for the quick reply...........It works perfectly

stuart


Chip Pearson wrote in message
...
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.