Quote Originally Posted by curiouscat408 View Post
@Russ.... Can you remove the "[SOLVED]" tag for the thread, since the problem has not, in fact, been solved to your satisfaction?



.... When you do what, or when what happens?!

Do any of your VBA modules "temporarily" set Manual mode?

And do you have any third-party VBA code?

My guess is that some VBA code accidentally leaves the calculation mode in Manual when it terminates or aborts.
Post #1 marked unsolved.

This occurs every time I open the WB. IE, I can go to the menu bar, set calcs to auto, close the WB, reopen the WB and it shows set back to manual. Getting late here so I'll try your debugging tips tomorrow, thanks!

No manual calc set anywhere in any code.

No 3rd party add-ins at all. I do have this date picker, but it only gets called by a button placed on the main WS, and I've avoided doing that while trying to figure this out.

I've also "compiled" the VBA code (never knew what that did until snooping around here!) and it throws no errors.

Any insight on that debug window as far as event order? Looks like the iterated WS_Calculate events are running first, then the macro "borders", finally WB_Open. Is that the correct order in the immediate window or am I backwards?

Thanks!

Russ