Help, my excel macro is not working?

Asked By Patricia C Lahr 20 points N/A Posted on - 01/04/2015

Why is the macro I recorded with Microsoft Excel 2013 not working when I run the macro? I recorded the macro for some cell formatting (Font, Border and Header) and the macro was properly recorded but when I ran the macro, it was not working. I have check the code in Vba and the code is okay. What should I do to make the macro to work?

• Status: Open
• Question Views: 608
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Kenry Fal 0 points N/A #192454

Help, my excel macro is not working?

Hello Patricia C Lahr ,

                                        Make sure that excel is in edit mode or note. If excel is in edit mode then macro will not work properly. When we edit any cell then macro will  not work. Check the excel security setting. Set the excel security setting to medium, if it is high then macro will not run. Check that excel is protected with password or not. If excel is protected then macro also will not run.

About Kenry Fal

Questions
0

Answers
99

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 01/09/2015
• Question Category: MS Excel