I created a simple macro to update information in other workbooks. I wrote it on my personal computer and tested it on my work computer. It works fine on both of these computers. When I distributed it the program failed. It can not reconize the other open workbook that it is supposed to update. My personal computer is XP Home and my work computer is Windows 2000. The newer work computers are XP Proffesional. I know it must be a security setting but I can not locate it. The Macro Security option to Trust access to Visual Basic Project is checked but the control is not enabled. Does anyone have an idea what is going on.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel not recognizing other open workbooks
- Thread starter Jerry56
- Start date
Similar threads
- Question
- Question
