question

vladimirkosik-5798 avatar image
0 Votes"
vladimirkosik-5798 asked ·

excel macro

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


not-supported
error-message.png (52.2 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered ·

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


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

toanash avatar image
0 Votes"
toanash answered ·

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

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

vladimirkosik-5798 avatar image
0 Votes"
vladimirkosik-5798 answered ·

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.

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Surrogate-7040 avatar image
0 Votes"
Surrogate-7040 answered ·

@vladimirkosik-5798

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

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



stepinto.png (34.1 KiB)
· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VladimirKosik-0188 avatar image
0 Votes"
VladimirKosik-0188 answered ·

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.

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Surrogate-7040 avatar image
0 Votes"
Surrogate-7040 answered ·

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

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VladimirKosik-0188 avatar image
0 Votes"
VladimirKosik-0188 answered ·

thank you

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.