Excell for Mac Microsoft Visual Basic Invalid procedure call or argument

Question

Hello friends! I have an issue while opening the macro Excel sheet on my Mac.

During an attempt to open an Excel doc, an

"Invalid procedure call or argument" error message pops up. By pressing OK button this message appears again and again.

I have to use force quite otherwise there is no other way how to escape from this error and close the program. A macro document has been created on Windows. I would appreciate it if you could advise me on how to solve this issue. Thank you beforehand.

Answer 1

Hello.

Many thanks for your detailed advice.

Unfortunately, I have been swamped the last few days and did not check the code and everything because it is not urgent for me now.

Anyway, thanks for your concern.

Answer 2

I think you'll need to disable macros, then review any code that is triggered in or by either a Workbook_Open or Auto_Open routine. The message would suggest that there is probably error handling in place that prevents debugging the code.

Answer 3

Dear Rory, many thanks for your reply. But, unfortunately, I do not have any clue how to fix this document. I was wondering if you could attached some photos with steps was advised by you.

Answer 4

Fixing your own coding mistakes is challenging enough. Troubleshooting someone else's code adds a layer of complexity.

Use the Menu Bar and choose Tools > Macro > Visual Basic Editor to get into the editor. In the upper left panel you'll see projects listed. Click the + sign next to the name of the workbook that has the problem. Then look for a folder called Modules. Inside that folder you should find the visual basic code modules. You'll have to read the code and try to make sense of it.

There are lots of help topics on the web to help you learn the VB Editor and how to code. Here's one: https://learn.microsoft.com/en-us/office/vba/library-reference/concepts/getting-started-with-vba-in-office

Answer 5

Hello, Jim.

Thank you very much for your kind reply. The thing is, code isn’t mine and I just need to work with this document.

Have a great day!