events

[Mark]

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

 

[Tom Ogilvy]

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.