Can I get Personal.xls code or any other code to run when a particular Excel file opens?
What I'm thinking is that, since Personal.xls will open when Excel is started, it may be possible to get the code in Personal.xls to run automatically, and to check whether the file I want to use is also open. If it isn't, exit the code, but if it is, then run the rest of the code.
Up to now, I've used a Command Button UserForm to start the code in Personal.xls, after first opening the file I want to use.
Are there any dangers in doing this? The code is to be used by several people in a LAN.
Thanks in advance.