Holding a variable in a dormant macro

[jasonb75]

Not sure if my title is misleading but didn't know how to refer to this problem.

I need to hold a variable (a) in a macro,

this needs the value of a = 0 when the workbook is opened

but needs to be changed to a=1 after the first run of the macro and retain this value for as long as the workbook remains open.

I'm guessing I'm going to feel rather stupid when someone gives me an answer that should have been obvious.

Thanks in advance.

 

[jasonb75]

Good to see you in here Mike, I think as always your answer has just solved many problems.

I've not come accross Static before but it sounds like what I need.

Thanks very much for your input

 

[jindon]

That looks like a better option Jindon,

I'm assuming that default would be Pubflag = False

In the code would "If PubFlg Then" Mean "If Pubflg = True" or "If Pubflg = False"?

Sorry for so many questions but not used this before.

Thanks again.

Correct.

 

[jasonb75]

Thanks to all for their help and input on this, now managed to finish what I was trying

For anyone interested, I now have code that simulates excel 07's group function, with the expand / collapse link on the visible cell above the hidden range.

Seems a bit more user friendly than the built in version, and as far as I can see works on 03 as well, maybe older versions too.

Still has a few limitations but I'll be working on those later.

I'm sure it's been done before but when I was discussing it with others a while ago the general opinion was "not possible"

Nice to prove the sceptics wrong