How to Check EnableEvents status without using VBA

Oh Dear !
Thanks for the info.

Please Login or Register  to view this content.

Just a thought,

Is it possible that the macro security level controls/determines this situation, unless it has been altered by VBa?

Have you run some code that disabled events and failed to re-enable after running, hence you need to know the status?

Originally Posted by Marcol

Just a thought,
Have you run some code that disabled events and failed to re-enable after running, hence you need to know the status?

Thats right Marcol.
One user is having repeatedly his EnableEvents set to false. That person uses many excel sheets(all with macros).
Unfortunately in that persons excel I can NOT ad an add-in nor modify the persnoal.xls nor any other VBA coded solution.
So far, being able to check (without any VBA code) the Enable events status would help a lot.

[QUOTE=Marcol;2313655]Just a thought,
Is it possible that the macro security level controls/determines this situation, unless it has been altered by VBa?
QUOTE]

I guess not. As far as I know, the security level will enable/disable/ask for macros as a whole. If you choose not to allow then no macro at all will work.

@snb: Thanks for your time anyway!

Yes I didn't mean that the macro security level would show you the status.

The most common reason for EnableEvents to be disabled, is probably in the Worksheet_Change Event

If there is no error trapping then Events are not reset.

Another common source is when a sub is exited to comply with some rule or another.

I'm sorry there is only one way to deal with this, Fix the error at source, or live with it.

Best of luck!!!

And again.....Oh Dear !! (I control only one of the workbooks that that person uses).

But Thank you all for the help.