Must be missing something simple here. Anyway, thought I would post it so someone can point me in the right direction.

I am trying to use the value of a name which is stored in workbook A from Workbook B. The name is called "debugmode" and stores a True/False value.

VB Code:
  1. Sub dosomething()
  2. If Workbooks("One").Names(debugmode).Name = True Then Cancel = True
  3. End sub
I get a subscript out of range error.

And then I tried a variation:
If Workbooks("tbm_intro.xls").Names("debugmode") = True Then Cancel = True
And got a type mismatch error.