Is there a way to declare a variable that will be recognized by open excel
files? For example if I have 2 files and in File1 I set a variable
vAllFilesVariable = "It works" then if I am in File2 and put MsgBox
vAllFilesVariable on the SelectionChange is there a way to make it so it
would return the variable?

Thank you,

Steven