2

Defined Names are normally defined at the worksheet or workbook level. But it is also possible to define them at the Application level using an old xl4 macro call. They thus become a place to store state that does not get reset when a VBA project is reset (e.g. due to an error).

This is an old trick, but I cannot remember how to do it. And not much documentation - some people must think that xl4 is obsolete.

ZygD
  • 22,092
  • 39
  • 79
  • 102
Tuntable
  • 3,276
  • 1
  • 21
  • 26

1 Answers1

2

Chip Pearson has it documented here: http://www.cpearson.com/Excel/hidden.htm

Community
  • 1
  • 1
Rory
  • 32,730
  • 5
  • 32
  • 35