Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I think it has to do with the Excel10.xlb. I copied the
personal.xls and the Excel10.xlb from my work computer to my home computer so that I would have the same menu and macros at home. I put Personal.xls in the XLStart just like I have it at work. Now when I open a new file in Xcel and personal.xls opens as a hiden file (as it should). However, when I press on the macro button on the toolbar or in the menu it says that personal.xls is already open and can not open two xls files with the same name. Unfortunately, now the same thing is happening at work. If I take Personal.xls out of XLStart then the macro will work. If I leave it in SLStart and make a new macro button it will work. Therefore, this seems to be something with a pointer in the menu item but nothing has moved on my work drive. I did open the Excel10.xlb file by mistake and think I remember hearing that you are not suppose to open a xlb file. Does anyone have any answers other than make all my menus and toolbars over again that use Personal.xls macros. Thank you |