I recently purchased the macbook pro and office for mac but noticed that all the macros created in Windows Excel were in the 'design mode' when opening the excel in mac. I would appreciate if anyone can help me with the followings: (i) Do I need to check the Developer box under ribbon preference? and (ii) How can I turn all the previous macros back to the 'execute mode' please? Thanks!
windows excel macro not working in macbook pro
- Thread starter pettycash
- Start date
- Joined
- Jan 23, 2008
- Messages
- 65,248
- Reaction score
- 1,833
- Points
- 113
- Location
- Keller, Texas
- Your Mac's Specs
- 2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
The reason the Excel macros are in the design mode is because they need to be recompiled for Mac OS X. Straight macros from Windows Office generally will not work in OS X. There are some that will but are very basic. There are many articles which you can find by using Google that will show you how to convert a Windows Excel Macro to one which will work with Mac OS X.
- Joined
- Nov 15, 2009
- Messages
- 17,614
- Reaction score
- 1,079
- Points
- 113
- Location
- North Louisiana, USA
- Your Mac's Specs
- M1 MacMini 16 GB - Ventura, iPhone 14 Pro Max, 2015 iMac 16 GB Monterey
I haven't looked at this since updating to Office 2011 for Mac but I don't think so. The last time I worked with Excel Macros the problems weren't differences in logic but some differences in commands. There were some commands that were platform specific (i.e. existed on Mac but not on PC or vice versa). There was usually an equivalent command.
Shop Amazon
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.