How to stop user from press a UserForm button when editing a cell (Mac)

[mcomp72]

I have a workbook that is used on both Windows & Mac -- probably 80% on Mac. I'm developing a new feature involving a UserForm that will be modeless. Basically, the UserForm will have buttons, and when the user click one of the buttons, it will record the address of the ActiveCell.

I've discovered a problem on Excel for Mac that doesn't happen on Windows. If I am editing a cell and then press one of the buttons of my UserForm, it causes a 1004 error. I would like to make it so if a user is editing a cell, they would not be able to click on buttons in the UserForm. This seems to be the default setting on Excel for Windows, but not on Mac. Anyone have any ideas how I'd accomplish this?

 

[mikerickson]

What version of Excel are you using, AFAIK Mac does not support modeless userforms.

 

[mcomp72]

What version of Excel are you using, AFAIK Mac does not support modeless userforms.

I'm currently testing it on Excel 365/2019. The userform opens just fine as modeless. I believe it's only Excel 2011 that doesn't support modeless.