Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Worksheet_SelectionChange macros
Hi All.........
I am trying to disable all change-event macros (or even ALL macros) upon opening a second workbook, with my code in the first workbook so the first workbooks macros will function without any interference from the second workbook macros. I've tried Application.EnableEvents = False workbook.open and tried Sec = Application.AutomationSecurity Application.EnableEvents = False Application.AutomationSecurity = msoAutomationSecurityForceDisable workbook.open both seem to work, but when I then use a line like Activesheet.UsedRange.SpecialCells(xlCellTypeFormu las, 23).Count It starts to run the "Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)" macro for the Sheet in the second workbook that is active. I would like it to NOT do that. Any assistance would be much appreciated. Vaya con Dios, Chuck, CABGx3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Worksheet_SelectionChange macros
Not sure if it helps but disabling events is an application level setting. So
if you disable the events in workbook 1 then no events will fire in either workbook. Just make darn sure you switch the events back on when you are done Application.enableEvents = false Activesheet.UsedRange.SpecialCells(xlCellTypeFormu las, 23).Count applicaiton.enableevents = true -- HTH... Jim Thomlinson "CLR" wrote: Hi All......... I am trying to disable all change-event macros (or even ALL macros) upon opening a second workbook, with my code in the first workbook so the first workbooks macros will function without any interference from the second workbook macros. I've tried Application.EnableEvents = False workbook.open and tried Sec = Application.AutomationSecurity Application.EnableEvents = False Application.AutomationSecurity = msoAutomationSecurityForceDisable workbook.open both seem to work, but when I then use a line like Activesheet.UsedRange.SpecialCells(xlCellTypeFormu las, 23).Count It starts to run the "Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)" macro for the Sheet in the second workbook that is active. I would like it to NOT do that. Any assistance would be much appreciated. Vaya con Dios, Chuck, CABGx3 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Worksheet_SelectionChange macros
Thanks Jim, for both the response, and the important information. All is
well now in my little world......it works fine. The solution is not in just having the right answer, but in it's proper application. Thanks again, Vaya con Dios, Chuck, CABGx3 "Jim Thomlinson" wrote: Not sure if it helps but disabling events is an application level setting. So if you disable the events in workbook 1 then no events will fire in either workbook. Just make darn sure you switch the events back on when you are done Application.enableEvents = false Activesheet.UsedRange.SpecialCells(xlCellTypeFormu las, 23).Count applicaiton.enableevents = true -- HTH... Jim Thomlinson "CLR" wrote: Hi All......... I am trying to disable all change-event macros (or even ALL macros) upon opening a second workbook, with my code in the first workbook so the first workbooks macros will function without any interference from the second workbook macros. I've tried Application.EnableEvents = False workbook.open and tried Sec = Application.AutomationSecurity Application.EnableEvents = False Application.AutomationSecurity = msoAutomationSecurityForceDisable workbook.open both seem to work, but when I then use a line like Activesheet.UsedRange.SpecialCells(xlCellTypeFormu las, 23).Count It starts to run the "Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)" macro for the Sheet in the second workbook that is active. I would like it to NOT do that. Any assistance would be much appreciated. Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Macros through VBA | Excel Programming | |||
disable macros? | Excel Programming | |||
Disable Macros through VBA | Excel Programming | |||
How to disable macros? | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |