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.