My Excel Spreadsheet VBA Crashes on opening

[LoriMaine]

Hi, I'm new to this forum. I'm having issues with a form I created on my Mac (Catalina; IOS Version 10.15.7) using Excel (version 16.9 copyright 2021).

I keep a log of all capital assets for my company and it was working...once I had all my VBA in place and now when I open the file, it causes all of these errors and no matter what I do, I cannot save the file or even copy it into a new file and still have my VBA working. I have no idea what I've done wrong and have been trying to find ways to avoid using VBA, but for what I'm trying to do, that seems impossible.

Any ideas? Much appreciated.

Lori

 

[Logit]

I am not familiar with MAC OS. I've always used Windows.

Having said that, here is a resource where SOME of the suggested fixes MAY work for you :

10 ways to recover a corrupted Excel workbook

Another idea (may not work for Mac OS) :

1) press <SHIFT> -button down ( and keep it pressed )
2) click to open Your Excel-file
3) release Your <SHIFT> -button
4) modify Your code as You want

 

[LoriMaine]

So I just tried something to see if it made a difference. I opened and used the file on my husband's Windows machine and there were NO errors and NO problems. But every time I open the file on my Mac, it has a boatload of errors and won't save. I'm at a loss. Is Excel really that picky with Macs?

 

[Logit]

Is Excel really that picky with Macs?

No ... I don't think so.

Did you create the workbook on your Mac or in a Windows environment ? If a Windows environment, there may be some parts of the workbook code that does
not agree with a Mac.

Otherwise, you'll just have to research your code to see what part / s cause the issue and rectify. Of course that will be a tough hurdle if it constantly crashes
your computer.

There have been a few instances, even in the Windows environment, where I've had to completely rebuild a workbook from scratch. That is a tough solution.