MACRO Recorded and saved does not run the second time.
 

"helene and gabor" wrote in message news:...
Hello,

The Macro was created on a Vista system.

Steps:
Developer
Record Macro
Macro entered
---------------
Record Macro
Macro name: month
Sto Workbook
OK
-----------------
Macro was then entered
Stop recording

Developer
Visual Basic
Macro name shows as:month
Run
The macro ran OK
---------------------------.
once mo Run Macro
edit
Save Book1 save as type: Excel Macro Enabled Workbook
save

developer
Macro security
Macro setting Enable all Macros
Trust access to the VBA project object model
---------------------------

When I tried to run it once more, the Run Macro
had no macro name, and entering:month did not make it possible to; RUN

Thanks for any help!

Gabor

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