vba Excel - passing public variables

[ChrisTheAncient]

I have found what, to me, is an unusual problem!

I can pass public declared boolean flags between procedures with absolutely no hassle.

Except...

In Excel, the Sub Auto_Close() procedure seems to set any of these flags back to 'False' as the sub proc starts running - no matter what I do! And I need them to stay true (

Has anyone had/cured/got round this problem?

Chris

*************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[combo]

Could you give more code details?

combo

 

[ChrisTheAncient]

Hi Combo

I eventually cured all my problems by going down the BeforeClose route.

Chris


*************************************
OK, I'm stoopid. But I'm good at it!
*************************************