View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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?