Global variable not retaining value

Good Morning All,

I'm having a problem with a global value retaining its value between the workbook_open event and module code.

I have the following declared above everything else in my Thisworkbook module

Please Login or Register  to view this content.

At the end of my workbookopen event I have

Please Login or Register  to view this content.

when debugging (f8) PUB_PWORD has a value of 0 as expected until it hits the ends sub where it becomes 'empty'

I have a module that is checking the value of PUB_PWORD and i its not 1 running code before setting it to the value of 1

I know I could store the value within a worksheet cell but as I only needed to retain value for the user session didn't think it would be required.

any ideas why this might be failing?

Hi, Kramxel,

Global Variables should be placed in a Standard module. In ThisWorkbook they would only be known in the module not in the workbook. Please add the missing backslash at the code-tag in your second procedure (if not done by now).

Ciao,
Holger

I think you should put the public variables in a regular module, not in ThisWorkbook module