If anyone who is good with VBA (I only have very basic knowledge, i.e.

Mac (or at least tell me that I am screwed and need to run Windows), I would be so eternally grateful.

The format is Excel 97 - 2004 Workbook (.xls) I have tried saving it as a.xlsm file but it made no difference.

There are so many modules and user forms I dont even know where to begin.

Recording Ros Excel 2011 Zip File Because

If someone could take a look at it that would be wonderful (I had to attach it as a zip file because it was too large to attach the workbook (1.77 MB).

Thanks for reading -Kyle.

The first thing is that it uses ActiveX controls, but Mac doesnt support ActiveX, but it does convert them into shapes.

What you have to do is go through all the sheet modules and change all the Private subs into Public.

Recording Ros Excel 2011 How To Use The

Then you have to figure out how to use the user forms that are being called (what kind of twit uses different forms for Add and Edit, they are the same functionality.).

I replaced the ActiveX-type buttons with three new Form-type buttons Moved their three procedures from the worksheets code module to a new code module called Buttons Assigned those three procedures to the three new buttons This only addressed the three buttons issue.

Sheet: Monte Carlo Simulation, Button: Run Economic Analysis.

Is there any way you can go through and do what you did with the three buttons on the first sheet to those four buttons on the other sheets, or explain how you did it (I know you already did but like I said my VBA is meh) I can PayPal you some cash for the trouble, I really appreciate the help here.

Recording Macros Excel For Mac 2011