Thread: events
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_17_] Mark[_17_] is offline
external usenet poster
 
Posts: 95
Default 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