Passing Working Storage between Excel Events

Within the VBA code of my worksheet, I am trying to pass some working storage values from the Workbook_Open event to the Workbook_Before Save event.

The documentation I have read is that you CANNOT add any parameters to be passed within the Sub statement.

Any ideas would be appreciated. Thanks.

Hi,

If I understand correctly your question,
you should be declaring your variables beforehand in order for all the event macros to share these variables ...

HTH
Carim