static global variable?

Is there any way to make a variable accessible to all the procedures in a project while still making the value of that variable static once it gets assigned/calculated??

I have at least one variable that I'd like to use & refer to (not always in the same order) in at least half a dozen macros, but I want to make sure that the variable's value stays the same. I suppose I could theoretically reset & recalculate the variable at the start of each macro, but I'd definitely prefer not to.

So is there anything I can do to get a static global variable??

Thanks mudraker but unfortunately I don't think declaring it as a Public Const will work for me since the item that I need to be global & static is actually a Code Module (called 'CM'), not an integer or string etc. According to the VB Help File....

Constants can be declared as one of the following data types: Boolean, Byte, Integer, Long, Currency, Single, Double, Date, String, or Variant.

And if I just declare CM to be Public at the start of the whole module (or of each procedure it's used in), then won't its 'value' or 'definition' reset at the start of each procedure that's called? Or does declaring it as Public there mean that its definition/value is preserved across all macros & functions?? (I hope so!!)

Since nearly all of my macros (let's refer to them as 'primary codes') call 1 of 3 other CM-using procedures ('secondary codes') before they refer to CM themselves, what if I declared "Static CM as CodeModule" in each of those 3 secondary codes and then "Dim CM as CodeModule" in all of the primaryones? Then VB would be happy because CM would be declared at that start of all the primary codes, but because CM wouldn't actually be defined until a primary code called a secondary code, its 'value' would actually be Static because that's what the secondary code declared it would be. (follow all that??)

Would that work? Would declaring it as Public at the top of the module be enough? Or am I out of luck & just have to redefine CM at the start of all primary AND secondary codes that use it?

Thanks for your help so far!!

excellent. thanks so much. that's really helped a lot!