Hidden Namespace

TemiU

Board Regular
Joined
Dec 11, 2014
Messages
52
Hello all!

I just read a back and forth from July 2012 about using a Hidden Namespace to store a global variable, so that the values won't get reset when there is an error.

I would like to ensure that the Hidden namespace value gets "erased" upon close of the program, even if the file has been saved in the interim. However, if the file gets closed unexpectedly (e.g., through an error/ not responding), then I can not access "On Close".

Does the hidden namespace value get saved with the file when the user saves, or does it automatically get reset every time the file gets reopened?
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,223,264
Messages
6,171,085
Members
452,378
Latest member
Hoodzy01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top