Thanks for the quick reply craig49. I checked to the file extension and it is xlsm. It allows me to assign a macro to it. So I created an empty macro, then copied the code to it. Then I assigned the new macro to the button and it enables the button.

I have extensively used Excel on Windows for ~ 24 months and have used Windows for six years. Since the last 12 months, I have been using the Mac version of Excel (2011 version). The Mac version is pretty decent to work with. Question: Q: How to open vba code in excel on Mac Air? Some one sent me an xlsx file produced on VBA. On a PC you can access the code with Alt F11 but that does not work on Mac.

I really do not want to do this with the 15 buttons I have. Any other suggestions would be appreciated. I also open the developer toolbar and disabled the design mode. This did not work either. Thanks again. I also have a code that works fine in windows but doesn't in Mac.

It gives me a Compile Error - expected function or variable, and highlights 'select' on second row from bottom. Like i mentioned this code works fine in windows environment. Free microsoft office for students mac.

Hello ddnron, I did some snooping around trying to find an answer. But, there aren't many answers out there! I'm sure you are finding the same. Part of the problem is while Office 2011 does have VBA in the 'feature set' the Mac version is like 'VBA Lite.' MS either chose not to include a full VBA feature set or chose one that works most of the time.

ActiveX, for example is not supported in 2011. While it is documented, no mention is made that it is not supported.

The previous version of Office for Mac didn't have any VBA support and apparently there was no active development for years. When it was decided to include VBA in 2011, the development team was rushed to 'catch up' with years of development on the Windows side. So, it is amazing that VBA 2011 works as well as it does. The frustrating part is that MS just says, 'It's got VBA,' and forgot the part about 'but, it isn't the fully functioning version.' That's marketing.

However, it helps lots of folks make good incomes writing books and consulting. Sorry I couldn't have been more helpful. Thanks agian for your reply craig49. My snooping has lead me in the same direction as you, there is not much out there. I'll just create macros, without code, and copy my code into them, then assign. I can go to Mac VB and run the codes from there. All except the one I posted.

I'm by no means an expert at VB, but the Mac version just does not have all the functioning tools as windows. Good thing I have both operating systems in the house. I think I'll send Microsoft a note about the codes working in windows, but not Office Mac. See what they say. Thanks agian for you help and time Craig49. Hello ddnron, I did some snooping around trying to find an answer. But, there aren't many answers out there!

If you’re not following these tips, you’ll lose whatever potential benefits an ergonomic mouse provides. Cornell University has published, gleaned from the university’s mouse research studies, which include: varying your posture; holding your mouse gently; making controlled movements with your mouse, using your elbow as the pivot point; and keeping your wrist free of surface-pressure contact. Ergonomic mice for mac.

I'm sure you are finding the same. Part of the problem is while Office 2011 does have VBA in the 'feature set' the Mac version is like 'VBA Lite.' MS either chose not to include a full VBA feature set or chose one that works most of the time. ActiveX, for example is not supported in 2011. While it is documented, no mention is made that it is not supported. The previous version of Office for Mac didn't have any VBA support and apparently there was no active development for years.

When it was decided to include VBA in 2011, the development team was rushed to 'catch up' with years of development on the Windows side. So, it is amazing that VBA 2011 works as well as it does. The frustrating part is that MS just says, 'It's got VBA,' and forgot the part about 'but, it isn't the fully functioning version.' That's marketing. However, it helps lots of folks make good incomes writing books and consulting.

Sorry I couldn't have been more helpful.

See solution in other versions of Excel: • • • • • Question: How do I draw a line through a value in a cell in Microsoft Excel 2011 for Mac? (This is also known as a strikethrough.) Answer: Select the text that you wish to strikethrough. This can either be the entire cell or only a character in the cell. While your mouse is over the selected text, right-click and then select 'Format Cells' from the popup menu. When the Format Cells window appears, select the Font tab. Check the Strikethrough checkbox. Click on the OK button.