Two Personal.xls Files

G

Greg's News

I have 2 personal.xls files in different directories. At startup one opens.
Both personal.xls are identical. The problem I have is a custom toolbar that
refers to the closed personal.xls file. I have many buttons on the toolbar.
Is there a way I can change the file path to the referenced personal.xls to
the open personal.xls file or do I have to change each button one at a time.
TIA

Greg
 
M

Myrna Larson

Try this. Move the file that is loading automatically out of the XLSTART
directory. Then click on one of the buttons so it loads your "closed"
Personal.xls file. Once you've done that, unhide the Personal.xls window,
File/Save As to save it to your XLSTART directory. Then hide it again. When
Excel closes, it will ask you whether to save the changes to Personal.xls (the
change is the hiding). Say yes. This should update the file to which the
buttons refer.
 
G

Greg's News

Myrna, thank you very much. I got it to work. I was afraid I might have to
go into the registry and adjust the startup location for Excel.

Greg
Try this. Move the file that is loading automatically out of the XLSTART
directory. Then click on one of the buttons so it loads your "closed"
Personal.xls file. Once you've done that, unhide the Personal.xls window,
File/Save As to save it to your XLSTART directory. Then hide it again. When
Excel closes, it will ask you whether to save the changes to Personal.xls
(the
change is the hiding). Say yes. This should update the file to which the
buttons refer.
 
Top