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

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

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