Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't know. Could you post the workbook somewhere on the web (not this
NG)? -- HTH Bob Phillips "Intellihome" wrote in message ... Hello Bob, No, I am not using Automation Server, but EnableEvents works as described in this article. and I do not know what the problem with it. It just does not work. If that is not a problem then what? I can have for example a procedure that handles ComboBox1_Change() then somewhere else in the code I can say: Application.EnableEvents = False Sheets("WhatEver").ComboBox1.Value = 1 ^^^^^^^^^^^^^^^^^^^^^^^^ after this line event will be intercepted by event handler and handling procedure will be executed, even though EnableEvents is set to False. Why do you think this could be? Ivan -- Intellihome ------------------------------------------------------------------------ Intellihome's Profile: http://www.msusenet.com/member.php?userid=1479 View this thread: http://www.msusenet.com/t-1870532558 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove/disable event macros in SavedAs wkbk? | Excel Programming | |||
problem with beforeclose event | Excel Programming | |||
ThisWorkBook BeforeClose Event | Excel Programming | |||
ThisWorkBook BeforeClose Event | Excel Programming | |||
BeforeClose event - Savings | Excel Programming |