In the most recent development sprint on the Productivity Macros, we focused on getting all of the new and existing keystrokes working on Excel for Mac.
This turned out to be more challenging than expected.
Excel for Mac cannot "see" some of the modifier keys that we use in the macros - specifically the Command or Option key (Alt key on Windows). This much we knew. There used to be a Python-based workaround.
However, Python is no longer built into Monterey, the latest macOS upgrade.
Patrick O'Beirne, one of the VBA developers who work on the macros, has written about the issue in more detail on his blog.
This left us with some tricky keystroke decisions. Many people have used the macros for many years, and the keystrokes are "baked in" to existing training materials. We wanted to avoid changing existing windows keystrokes as much as possible.
A number of our macros use the Ctrl+alt keyboard combination. These are the ones that caused us the problem.
Patrick has come up with a clever solution that does allow the Option key to be used, just not in the Ctrl+Option configuration. This has allowed us to leave the Windows shortcuts unchanged and create Mac-specific versions of the Ctrl+alt keystrokes.
These keystrokes are activated using Shift+Control+Option.
I know. It's a lot.
But in testing, I found that the position of those keys on the Mac means that they're not difficult to press together, and the replacement is consistent, meaning you can use the combination across all Ctrl+alt keystrokes.
I'll be updating all of the relevant sections of the handbook with the Mac-specific keystrokes.
In the meantime, I'd appreciate our Excel for Mac users testing out the latest version.
Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.