Public Worksheet Declaration

I'm using a public declaration for a worksheet but I seem to have to initialize it in each routine. Is there a way to set it and leave it?

So in a module I have:

Please Login or Register  to view this content.

It will stay set indefinitely (i.e., until you push the reset button, execute an End statement, or explicitly clear it) after it is initially set.

If you have several macros that you run individually you need to set it within each macro.

If you call a macro from another macro then you only need to set it within the 1st run macro

Could you clarify what you mean by "end" statement? Obviously it isn't an "end if" but how about "end sub" or "end function"?

What is the "standard" way of doing this? Do many people do their declarations in the workbook_open event?

*Edit*
Ok, mudraker's answer is what I was looking for.

clarify what you mean by "end" statement

Please Login or Register  to view this content.

See VBE Help for End Statement