Store variable values in macro code

Afternoon all,

I am working on a concept of storing values of variables in macros code on a permanent basis.

Or put in another way, I'd prefer not to have my values obtained from macro calculations to be stored in an excel sheet, as the sheets can be deleted by an uninformed user.

I also need these values to be obtainable at a later stage, thus the storage need to be of a permanent sort.

Is this possible in any way?

Thanks in advance.

You can store the values in,

- worksheet. Hide and protect if you do not want users to see/alter the values.
- names
- workbook custom properties
- external data file
- registry

Hi Andy,

Thanks, storing values in names is just what I was looking for.