I have a complex spreadsheet that makes extensive use of VBA, including Command Buttons and Event Handlers. I have developed it over quite a few years, and therefore quite a few versions of Excel, but only ever on Windows versions of Excel. It is able to be run on all Excel versions from 97 to 2010. I have had a request to provide a version for the recently released Macintosh version of Excel, 2011. The marketing material for Excel 2011 claims that it provides full support for VBA, and if this is truly the case then the conversion task should be trivial. Does anyone have any experience converting a VBA-ridden Windows-based Excel spreadsheet to Excel-2011?

You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor. First, be sure that the Developer tab is visible in the toolbar in Excel. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc. Microsoft Office for Mac 2011 tutorial: Automate tasks with Visual Basic macros 2 1. Show the Developer tab The Developer tab is a specialized ribbon tab that contains commands for working with macros.

What sort of difficulties were encountered? Alternatively, is anyone aware of a document somewhere on the Internet that gives an impartial and independent review of the degree of interchangeability between the two platforms? [I posted this query on the Tek-Tips site a week ago, where it elicited nary a response.] RE: Running Windows VBA on Excel 2011 (Macintosh) (Aerospace) 22 Feb 12 00:08. I got a brief chance to test my spreadsheet on a Mac when I was at a social function last night. I just happened to have it on a memory stick in my pocket, and while my wife was distracted I turned antisocial and fired up our host's Mac. Results, such as they were, were very discouraging. Adobe acrobat reader dc pro for mac download. In the couple of minutes I had before my absence was noticed I discovered: (1) The 'welcome' form that fires up when the spreadsheet is opened is supposed to close itself down automatically after 5 seconds, unless the user closes it earlier.

On Mac the auto closedown did not work. (2) None of the command buttons responded in any way when clicked upon. (3) However I was able to initiate the running of VBA code with my ctrl-shift-X style shortcuts.

(4) Some (maybe all?) reserved constants such as xlPending caused 'variable undefined' errors. I had no time to look into workarounds for these before being led by the ear back to the gathering. However I was unhappy with the experience, and will probably decline the request to produce a Mac version of the spreadsheet. (One of the conditions I imposed on myself was that the same version of the spreadsheet be able to run on both platforms, because I am not at all interested in having to maintain two versions. My conclusion from my brief experience suggests that even if I was to put in the effort to get a Mac version working, the result would not work when ported back to Windows.) Despite this, I am still interested in unearthing any succinct document about the difficulties I might encounter were I to attempt the conversion. RE: Running Windows VBA on Excel 2011 (Macintosh) (Mechanical) 24 Feb 12 15:01.

Google voice desktop client for mac free. • Share images using drag and drop.