On 3 Jun, 21:46, Dave wrote:
Hi,
Not sure if this is what you're after, but sometimes when I want to preserve
a variable, even after a workbook is closed, I store it in an out-of-the-way
cell.

I already do that, the macro has half a dozen hidden sheets containing
config data. However, these variables are Objects. There might be some
fun to be had squirelling them away in the OLEObjects collection, but
that does seem a little Byzantine.