events

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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.
 
Back
Top