View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default MACRO Recorded and saved does not run the second time.

Hi helene and gabor,

I also had problems with the macros when I first migrated from xl2002 to
xl2007. If my memory serves me correctly, the macro security to allow macros
had to be set first before saving any macros. Even a file that I migrated
from xl2002 and then saved as macro enabled workbooks in xl2007 lost the
macros. (I did have backups).

I think that I finished up setting the macro security to allow macros then
closed Excel and re-opened Excel and then everything worked fine. (Not sure
if closing and re-opening did anything but that is how I did it because I
wanted to go back to the options and see if they were still set as required.)

--
Regards,

OssieMac