Excel for Mac - Onkey

[dispelthemyth]

I have some code that is used by a few hundred people and some Mac users have started using it. I have bought a Mac to test the code as they are having issues.
Most of the code runs on OnKey presses, i.e. Ctrl+Shift+R

An issue they are facing is the use of the "Alt" key as that doesn't exist on the Mac, they have the Command key instead but I read that in some of the latest version of Excel for Mac that button doesn't work.

Do you know of any other buttons I could use instead of the Alt/Command key?

I could use some different Ctrl + Shift + New character or Ctrl+ etc but I'm trying to keep consistency by changing just the function key that is used

i.e. Ctrl+Alt+1 becomes Ctrl+NewFunctionKey+1

 

[sijpie]

I have no Mac to test things on. I do write macros for people with Macs though. I insert buttons on the sheets for them to run the macros.
If there is a choice of a larger number of macros to be run, i create a small userform with the various buttons, so as not to cloud over the sheet.