Thread
:
excel xp macros cannot be saved to personal.xls
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
Posts: 22,906
excel xp macros cannot be saved to personal.xls
I would first try HelpAbout MS ExcelDisabled Items.
See if Personal.xls got stuck in there after Excel didn't like something it did.
If so, try to enable it and see if you have access again.
To answer second question about storage.............
The most likely path to XLSTART is
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
Excel should find Personal.xls for opening in that folder.
Gord Dibben MS Excel MVP
On 2 Mar 2007 14:12:13 -0800,
wrote:
I have used excel a long time witout larger problems.
i have had a number of smaller macros that i have saved in
personal.xls, after first "unhiding" it. and then attached these
macros to toolbar buttons.
suddenly the buttons are gone and i cannot save a macro to
personal.xls, it needs to be unhidden?
and it turned out the personal.xls was gone!
I have a copy on an usb stick, but where shal i place the file? have
triede a couplle of folders: ...\xlstart\ but it does not work. so
where is the correct place and should i check other items too, so
excel knows its back?
i run xp pro sp2
kind regards
PAlle
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben