Hi all,</SPAN></SPAN>
I have a personal.xlsb file where all my macro’s are placed. Right now it is stored in the standard location; </SPAN>C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB. </SPAN>The problem is that when I want to work from home, I have to open my excel from a personal online drive (U-drive). When I open Excel via the U-drive I can’t use my macro’s, but I don’t know exactly how I can make it possible to have the personal.xlsb for both versions. I need it for the C drive and for the u Drive. Can I copy it somewhere in a location of the u drive? </SPAN></SPAN></PRE>
Does anyone know how I can fix this and use my macro’s at home? </SPAN></PRE>
Ps. If I try creating a new macro at home the system says that he wants to overwrite C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to save the macro.</SPAN></PRE>
I have a personal.xlsb file where all my macro’s are placed. Right now it is stored in the standard location; </SPAN>C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB. </SPAN>The problem is that when I want to work from home, I have to open my excel from a personal online drive (U-drive). When I open Excel via the U-drive I can’t use my macro’s, but I don’t know exactly how I can make it possible to have the personal.xlsb for both versions. I need it for the C drive and for the u Drive. Can I copy it somewhere in a location of the u drive? </SPAN></SPAN></PRE>
Does anyone know how I can fix this and use my macro’s at home? </SPAN></PRE>
Ps. If I try creating a new macro at home the system says that he wants to overwrite C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to save the macro.</SPAN></PRE>