B
Branden
I have a number of custom macro's in my PERSONAL.XLS
file. I've been using them without problem for some time.
Something has happened this morning and my common macros
from my PERSONAL.XLS are no longer loading. I'm using
office XP. Here are some things I have checked:
1. the PERSONAL.XLS file is in the c:\documents and
settings\GLH\application data\microsoft\excel directory
as always
2. when I open excel I don't see the macros. If I go to
the window menu and to unhide the personal.xls workbook,
I notice that the unhide option is disabled, as though it
is not opening.
3. if i open the personal.xls file manually, the macro's
are available and run fine.
4. I have checked the Tools > Options > General tab and
verified that the "At Startup, Open Files In" edit box is
empty, as it should be by default.
5. I do have a book1.xls workbook in the same xlstart
folder that loads some other defaults (such as headers
and footers) and it continues to load just fine
6. I have copied the macros from my personal.xls into a
new spreadsheet and renamed them, thinking that
personal.xls may have been corrupted in some way, but
that didn't work either.
7. I've checked to make sure that my shift key wasn't
sticking when opening up excel, realizing that such a
problem might bypass loading the personal.xls file
Any ideas why the personal.xls would not open when I open
excel? Any help is appreciated.
file. I've been using them without problem for some time.
Something has happened this morning and my common macros
from my PERSONAL.XLS are no longer loading. I'm using
office XP. Here are some things I have checked:
1. the PERSONAL.XLS file is in the c:\documents and
settings\GLH\application data\microsoft\excel directory
as always
2. when I open excel I don't see the macros. If I go to
the window menu and to unhide the personal.xls workbook,
I notice that the unhide option is disabled, as though it
is not opening.
3. if i open the personal.xls file manually, the macro's
are available and run fine.
4. I have checked the Tools > Options > General tab and
verified that the "At Startup, Open Files In" edit box is
empty, as it should be by default.
5. I do have a book1.xls workbook in the same xlstart
folder that loads some other defaults (such as headers
and footers) and it continues to load just fine
6. I have copied the macros from my personal.xls into a
new spreadsheet and renamed them, thinking that
personal.xls may have been corrupted in some way, but
that didn't work either.
7. I've checked to make sure that my shift key wasn't
sticking when opening up excel, realizing that such a
problem might bypass loading the personal.xls file
Any ideas why the personal.xls would not open when I open
excel? Any help is appreciated.