Hi
I have an issue to run my excel macro. When I press button 'RUN' then new error window pop up with following message: 'Microsoft Visual Basic for Application error: Visual Basic'. How I can fix it? Thank you! 8400-error-message.png
excel macro
Hi,
Q&A currently supports the products listed over here https://docs.microsoft.com/en-us/answers/products (more to be added later on).
You can reach the experts in the dedicated Microsoft Excel forum over here:
https://social.technet.microsoft.com/Forums/en-US/home?forum=excel
(Please don't forget to accept helpful replies as answer)
Best regards,
Leon
The Visual Basic, Macros, and Record Macro options are disabled under the Developer and View ribbon.
Hi @toanash
Thank you for your help but could you give me more information how to enabled visual basic, macros and record macro?
Thank you very much.
give me more information how to enabled visual basic, macros and record macro
Please read this article
https://support.office.com/en-us/article/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45
Also you can try execute your macro step-by-step, you can find line with error.
Press keys Alt+F11, select desired macro, and press key F8 or find Step Into command in Debug toolbar
Hi
Thank for your answer @Surrogate-7040 but macro code is password protected then I can not get into code and I dont know password.
This macro can contain mistakes or written for other Excel's edition. These mistakes may be is reason for this error !
You can download OpenOffice application (open sourse substitution of MS Office), in this application you can open protected macros without problems
thank you
7 people are following this question.
