Excel Visual Basic Editor Does Not… | Apple Developer Forums

• Global Nav Open Menu Global Nav Close Menu
• Apple Developer

Search Cancel

• Apple Developer
• News
• Discover
• Design
• Develop
• Distribute
• Support
• Account

Cancel Only search within “”

Quick Links

5 Quick Links Developer Forums Search by keywords or tags Submit Search Clear search query Choose an option: Search Post Profile ▲

• Sign in
• Create account

Search by keywords or tags Submit Search Clear search query Choose an option: Excel Visual Basic Editor does not open in Monterey App & System Services Core OS macOS You’re now watching this thread. If you’ve opted in to email or web notifications, you’ll be notified when there’s activity. Click again to stop watching or visit your profile to manage watched threads and notifications. You’ve stopped watching this thread and will no longer receive emails or web notifications when there’s activity. Click again to start watching. AlFromOttawa OP Created Jan ’22 Replies 4 Boosts 0 Views 1.8k 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 Copy to clipboard Share this post Copied to Clipboard Replies 4 Boosts 0 Views 1.8k Participants 3 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 comments 0 Copy to clipboard Share this post Copied to Clipboard Load more Add comment jpaulhiac OP Feb ’22

Same issue here. Same configuration.

0 comments 0 Copy to clipboard Share this post Copied to Clipboard Load more Add comment 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 comments 0 Copy to clipboard Share this post Copied to Clipboard Load more Add comment 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 comments 0 Copy to clipboard Share this post Copied to Clipboard Load more Add comment Excel Visual Basic Editor does not open in Monterey First post date Last post date Q