events
 

Hi,
I have events (in class module personal).
Events do (msgbox yes,no) if i open or create workbook and
activate sheet.
How disable events in curent workbook when msgbox-no,
but this events must be eneble to another workbook.

Unfortunately script:
Application.EnableEvents = False
disable all events in all (new or open) application
wokrbook
I must close excel and reopon again.

Thanks very much for any assistance

Regards
Mark

events
 

You can't disable events in a single workbook using code. You can manually
disable macros, but I don't think you can do it with code, at least not in
xl2000 and earlier.


--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
Hi,
I have events (in class module personal).
Events do (msgbox yes,no) if i open or create workbook and
activate sheet.
How disable events in curent workbook when msgbox-no,
but this events must be eneble to another workbook.

Unfortunately script:
Application.EnableEvents = False
disable all events in all (new or open) application
wokrbook
I must close excel and reopon again.

Thanks very much for any assistance

Regards
Mark