I"m running a MacBook Air M1 OS 14.1.
I'm running MS VBA 7.1
I'm using Excel for Mac Ver. 16.7 Office Home & Business.
The issue I have is when I run a macro when the sheet is protected it will crash.
When the sheet does not protect it the macro works fine.
I protect the worksheet and I don't run the macro there's no issue.
Has anybody got any ideas or what the issue might be.
When I protect the worksheet there's several radio boxes the check on what you want to protect.
When I protect the sheet I check all those boxes, to grant all access that I can.
But if you try to run a vba it will crash. You also have the option to protect a vba, however I made sure that that was not checked.
Thank you in advance for your time.
I'm running MS VBA 7.1
I'm using Excel for Mac Ver. 16.7 Office Home & Business.
The issue I have is when I run a macro when the sheet is protected it will crash.
When the sheet does not protect it the macro works fine.
I protect the worksheet and I don't run the macro there's no issue.
Has anybody got any ideas or what the issue might be.
When I protect the worksheet there's several radio boxes the check on what you want to protect.
When I protect the sheet I check all those boxes, to grant all access that I can.
But if you try to run a vba it will crash. You also have the option to protect a vba, however I made sure that that was not checked.
Thank you in advance for your time.
