Support Communities / Mac OS & System Software / OS X Mavericks. Announcement: Upgrade to macOS Mojave With features like Dark Mode, Stacks, and four new built-in apps, macOS Mojave helps you get more out of every click. In the cell content. I have unhide all the hidden rows, columns & worksheets still issue persists. The same works fine on Excel 2007 on windows platform. Has anybody faced similar issue or having any known KB article, which confirms that there are compatibility issues with Windows and Mac versions of MS Office.

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