windows excel macro not working in macbook pro

Joined
Mar 28, 2015
Messages
212
Reaction score
1
Points
18
Location
Toronto, ON
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!
 

chscag

Well-known member
Staff member
Admin
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.
 
OP
P
Joined
Mar 28, 2015
Messages
212
Reaction score
1
Points
18
Location
Toronto, ON
Thanks for the prompt reply. Does it mean that the macro-writing logic is totally different in Mac than PC?
 

Slydude

Well-known member
Staff member
Moderator
Joined
Nov 15, 2009
Messages
17,609
Reaction score
1,076
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.
 
OP
P
Joined
Mar 28, 2015
Messages
212
Reaction score
1
Points
18
Location
Toronto, ON
Thanks, and do you know where I can get a full list for conversion purpose?
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on 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.
Top