Excel Visual Basic Editor does not open in Monterey

Question

AlFromOttawa OP

Created Jan ’22

Replies 4

Boosts 0

Views 1.7k

Participants 3

I have an Excel worksheet with several macros that I wrote a couple of years ago. They work but I want to add features.

Opened the worksheet with macros enabled, selected a macro, and tried to edit it. The Window name shown in the Mac menu bar changed by appending - Module 1 (Code) but the Visual Basic Editor did not appear. I have tried various keystroke combinations suggested online without success.

Mac OS Monterey 12.0.1, Excel 16.57 (Office 365 subscription). New MacBook Pro M1Max. The macros were created on my old MacBook Pro 2012 which currently is running the latest OS it supports - Catalina. I think that is what it was running when I created the macros.

I will also be visiting Microsoft's Office forums, but I suspect that this may be an issue related to M1 chip or Monterey security features.

Boost

Answer 1

OOPer OP

Jan ’22

Whether or not it might be an issue related to M1 chip or Monterey security features, it is the responsibility of the author of the app to adapt it to work on M1 chip or Monterey. You will have a better chance to get answers on the sites related to Microsoft.

0

Answer 2

jpaulhiac OP

Feb ’22

Same issue here. Same configuration.

0

Answer 3

AlFromOttawa OP

Feb ’22

True that may be more effective. But it may also be an unintended issue in Rosetta or other OS features. Can't hurt to have it looked at from both sides.

0

Answer 4

AlFromOttawa OP

Feb ’22

I can't say with certainty whether it was fixed by Apple or Microsoft, but this issue is gone with my current configuration: Monterey 12.2.1 and Excel 16.67. Both were updated since I last experienced this issue.

0