Thread: Excel10.xlb
View Single Post
  #2   Report Post  
FGM
 
Posts: n/a
Default

Found a backup of the xlb file and copied that on and it
works. Therefore I can only think that it was because I
openned the xlb file. Would be interested in comments
from others.


-----Original Message-----
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

.