MACRO Recorded and saved does not run the second time.

H

helene and gabor

Hello,

The Macro was created on a Vista system.

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

Developer
Visual Basic
Macro name shows as:month
Run
The macro ran OK
---------------------------.
once more: 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Menu Macro Not Executing - Need Help 1
how to run a recorded macro in many files at a same time 1
Recorded Excel Macro not working 1
Unable to Record Macro in 2007 2
Cannot run the macro 'XXX' 0
VBA code won't run, even with Macro Security set to Enable All Macors 9
Accessing the PERSONAL.XLS without a macro ever recorded by user. 3

Top