Personal.xls

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I currently have a lot of personal macro buttons set up in
my Personal.xls template, which I sue to simplify many
tasks (eg, I have one that does "paste formulas" at the
click of a button, without using paste special).

However, sometimes, usually when there has been more than 1
instance of Excel open, when I close them all and rerun the
program, my personal settings have been lost.

I have tried backing-up Personal.xls and then copying it
back to restore them, but this does not work. It also does
not work when trying to copy Personal.xls between computers.

Is this a fualt of excel or am I doing something wrong?

Thanks

Dave
 
Dave,

Your toolbar settings and custom toolbar buttons are not stored with your
Personal.xls file. These are stored with the XLB file. If the XLB file
changes because of a Excel closure unfortunately there is no backup.

To correct this you can create code that will create the toolbars or buttons
when personal.xls is opened and set the action to point at the personal.xls.
Of course you can make the code check for existance first and set the action
then or even leave things alone. If you would like an example of this let
me know and I will provide it to you.
 
I concur with Chris' solution, if this is your issue.

Another method is to create a backup of your .xlb file, once you have
set up your toolbars and after successfully closing Excel without a
crash.

If your changes get junked by Excel, find the backup and double-click
this file and Excel will load your toolbar setup.

HTH
Paul
 
First restore the backup .xlb to it's original location,
but perhaps you assumed that a backup would naturally be
restored to it's original location and not just be a copy in another
directory. If you use from another location such as you might
have anyway if you work with another version of Excel and copy
your *.xlb file you may mess up the pathnames and have to
rename each one.
http://www.mvps.org/dmcritchie/excel/barhopper.htm

If you mess up your toolbars and have not closed Excel you can
simply open your current .xlb file and your toolbars and menus
will be restored. More information and backing up some files see
http://www.mvps.org/dmcritchie/excel/toolbars.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top