HWL
Active Member
- Joined
- Dec 1, 2009
- Messages
- 462
Well actually it's an issue with personal.xlsm 
I have developed a set of useful macros/userforms specific to my office/industry and have loaded this on several users computers in my office via XLSTART/personal.xlsm (version 2007).
It works perfect for almost all users except one. The problem is whenever he uses the CLOSE ALL quick access button, it appears to want to close personal and save it in the default pathway (where ever he was last) instead of in the XLSTART folder. This seems to cause a popup "Microsoft Visual Basic X 400".
A little research on this error http://www.mrexcel.com/forum/showthread.php?1721-Visual-Basic-error-400 however that doesn't seem to be what's going on since the first popup claims it failed to save personal.xlsm in where ever the user was defaulted. Help?
I have developed a set of useful macros/userforms specific to my office/industry and have loaded this on several users computers in my office via XLSTART/personal.xlsm (version 2007).
It works perfect for almost all users except one. The problem is whenever he uses the CLOSE ALL quick access button, it appears to want to close personal and save it in the default pathway (where ever he was last) instead of in the XLSTART folder. This seems to cause a popup "Microsoft Visual Basic X 400".
A little research on this error http://www.mrexcel.com/forum/showthread.php?1721-Visual-Basic-error-400 however that doesn't seem to be what's going on since the first popup claims it failed to save personal.xlsm in where ever the user was defaulted. Help?
