mcomp72
Active Member
- Joined
- Aug 14, 2016
- Messages
- 275
- Office Version
- 365
- 2019
- 2016
- 2011
- Platform
- Windows
- MacOS
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?
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?