ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MACRO Recorded and saved does not run the second time. (https://www.excelbanter.com/excel-programming/436551-macro-recorded-saved-does-not-run-second-time.html)

helene and gabor

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




All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com