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,370 questions
0 comments No comments
{count} votes

Accepted answer
  1. Leon Laude 85,581 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 No comments

3 additional answers

Sort by: Most helpful
  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