View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
helene and gabor helene and gabor is offline
external usenet poster
 
Posts: 58
Default MACRO Recorded and saved does not run the second time.

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