| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling Sheet Code
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling Sheet Code
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enabling/disabling a set of code from within a spreadsheet sheet | Excel Discussion (Misc queries) | |||
| Sheet Code | Excel Worksheet Functions | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| unprotect sheet in code and make sheet visible | Excel Programming | |||
| Help with some sheet code | Excel Programming | |||
Linear Mode
