Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
temporarily disabling subroutines
I have some subroutines with the following heading in several worksheets
Private Sub Worksheet_Change(ByVal Target As Range) They are set up to automatically set values when data is being entered and are working fine. The problem occurs when I have finished and I run another subroutine to clear all the data in the worksheets. It seems to take a long time now and i think it is because of the subroutines that are triggered when a change occurs. Can I put in my deleting subroutine code that temporarily disables the private subs and then enables them when finished. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
temporarily disabling subroutines
Application.EnableEvents=False
'do your stuff Application.EnableEvents=True Tim "NDBC" wrote in message ... I have some subroutines with the following heading in several worksheets Private Sub Worksheet_Change(ByVal Target As Range) They are set up to automatically set values when data is being entered and are working fine. The problem occurs when I have finished and I run another subroutine to clear all the data in the worksheets. It seems to take a long time now and i think it is because of the subroutines that are triggered when a change occurs. Can I put in my deleting subroutine code that temporarily disables the private subs and then enables them when finished. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling SAVE AS Temporarily | Excel Programming | |||
Disabling effects of cells (temporarily) | Excel Programming | |||
Subroutines vs. modules | Excel Programming | |||
common subroutines - add-in | Excel Programming | |||
Temporarily Disabling an Event Macro | Excel Programming |