Everything I read says that Excel Public VBA variables should retain their values across all open workbooks. I created two new, simple workbooks (Test1.xlsm & Test2.xlsm) with identical code:
Public Test As Boolean
Test = True
Test = False
If I activate Test1.xlsm & run "SetVarTrue", it changes the value of Test ONLY in Test1.xlsm . If I switch to Test2.xlsm, the value of Test remains "False". Works the same if I change the value in Test2.
How can I make Test TRULY PUBLIC across both workbooks?