View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sonia5880 sonia5880 is offline
external usenet poster
 
Posts: 1
Default Macro Will Not Save

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?