Help, my excel macro is not working?

Asked By 20 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #192454

Help, my excel macro is not working?

qa-featured

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.

Related Questions