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

mcomp72

Board Regular
Joined
Aug 14, 2016
Messages
181
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2011
Platform
  1. Windows
  2. 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?
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,980
What version of Excel are you using, AFAIK Mac does not support modeless userforms.
 

mcomp72

Board Regular
Joined
Aug 14, 2016
Messages
181
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2011
Platform
  1. Windows
  2. MacOS
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,394
Messages
5,636,050
Members
416,894
Latest member
Hari1992

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top