Share via

excel macro

vladimir.kosik 21 Reputation points
2020-05-21T09:44:19.007+00:00

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

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,941 questions
0 comments
Accepted answer
  1. Leon Laude 85,791 Reputation points
    2020-05-21T09:45:38.647+00:00

    Hi,

    Q&A currently supports the products listed over here https://learn.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

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anash Mohamed 1 Reputation point
    2020-05-21T11:56:48.91+00:00

    The Visual Basic, Macros, and Record Macro options are disabled under the Developer and View ribbon.

  2. Anonymous
    2020-05-25T02:26:19.687+00:00

    @vladimir.kosik > 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 ![developer-tab.png][1] 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 ![8576-stepinto.png][2] [1]: https://www.excel-easy.com/examples/images/developer-tab/developer-tab.png [2]: /api/attachments/8576-stepinto.png?platform=QnA

  3. Anonymous
    2020-05-25T10:07:46.06+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.