Macro Will Not Save
personal.xls should sit in the default folder XlStart. Files in that folder
are loaded automatically. As for why you do not see your macros that is hard
to answer. Try switching to the XLStart folder and see fi that fixes up your
problems...
--
HTH...
Jim Thomlinson
"sonia5880" wrote:
I keep trying to record and save a Macro just to find that it does not stay
saved. I have saved the Macro in the PERSONAL.XLS workbook and in the Open
Workbook that I record the macro in. Once I close those workbooks and reopen
them the macro is no where to be found.
Whenever I open the Personal Workbook I do get the security warning stating
"C:\Documents and Settings\Sonia's Login\Desktop\personal.XLS" contains
macros. I always click Enable Macros, but when I go to run the macro there is
no macros. I was thinking it may have something to do with me saving the
PERSONAL.XLS workbook on my desktop?
|