Desperately Need Help Running Macros on Mac Excel 2011

[stilettostiletto]

Hi all,

I am new to the forums and am having an issue I desperately need help with. I am a junior majoring in chemical engineering and am taking a Process Economics class where we have to use an excel sheet for process costing that came with our book (Analysis, Synthesis, and Design of Chemical Processes by Turton). Long story short, it was created in an old version of Excel for Windows and none of the macros/buttons will run on Excel for Mac 2011. If anyone who is good with VBA (I only have very basic knowledge, i.e. creating a user form, basic coding) could take a look at it and possibly even make it able to run on 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. The buttons show up as pictures and are unclickable. There are so many modules and user forms I don't even know where to begin. 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

[mikerickson]

My what a confusing workbook. I'm not surprised that the author didn't use Option Explicit.

The first thing is that it uses ActiveX controls, but Mac doesn't 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. And then go through that sheet and right click on the buttons and assign the appropriate sub to the button.

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.)

[AlphaFrog]

The buttons used were ActiveX-type buttons which are not compatible with Mac (as I understand it).

• I replaced the ActiveX-type buttons with three new Form-type buttons
• Moved their three procedures from the worksheet's 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. I didn't alter any code other than moving it to a new module. You may or may not have other issues with a Mac. I don't have a Mac to test with.

[stilettostiletto]

The buttons used were ActiveX-type buttons which are not compatible with Mac (as I understand it).

• I replaced the ActiveX-type buttons with three new Form-type buttons
• Moved their three procedures from the worksheet's 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. I didn't alter any code other than moving it to a new module. You may or may not have other issues with a Mac. I don't have a Mac to test with.

Wow the first sheet buttons are working now, thanks a lot for that! There are four more buttons on some of the other sheets (Sheet: COM Summary, Button: Add Materials. Sheet: Cash Flow Analysis, Button: Generate CFD. Sheet: Monte Carlo Simulation, Button: Run Economic Analysis. Sheet: User Options, Button: Update Preferences). 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. +repped

[AlphaFrog]

If you had given it a try, I think you would have figured it out. It was just three easy steps.

Going to bed now.