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
|