Hide Columns Macro - Working on Windows not working on Mac OSX
Hi,
This is very frustrating - I've been looking everywhere for an answer with no luck.
The below macro, assigned to a checkbox, works with no issues on Windows, but once moved to OSX it fails to compile successfully.
Please Login or Register to view this content.
Hi bcadar,
I looks like you are using 'Active X' CheckBoxes from the code. According to the following link, 'Active X' CheckBoxes do not work on the MAC. http://www.excelforum.com/excel-prog...ng-on-mac.html
It looks like you may have to change your 'Active X' CheckBoxes to Forms 'CheckBoxes'.
---------------
In Windows, Active X Controls do not play nicely with others, especially if you are hiding rows and/or columns. You are probably very lucky you did not have corruption in your Windows file caused by the 'Active X' controls.
Lewis
Hi LJMetzger,
Thanks for the quick reply!
I moved the code to a form checkbox and now it fails in windows - no errors - but once it hides the columns it no longer functions.
Checking and unchecking the box with no results.
Any ideas :S??
See the attached sample file for implementation of the following:
The easiest way in Windows is to:
a. Deleted
b. Deleted
c. Create an ordinary Code Module:
ALT F11 (for VBA) > CTRL R > Right Click ThisWorkbook > Insert > Module
d. Move your Sub to the new code Module and make it Public in the new code module and even change the name.
In ordinary code module Module1:
e. Assign the Macro to the CheckBoxPlease Login or Register to view this content.
Right Click on the CheckBox > Assign Macro > Select CheckBoxEventHandler
It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:
This option requires all variables to be declared and will give a compiler error for undeclared variables.Please Login or Register to view this content.
Lewis
Last edited by LJMetzger; 01-05-2016 at 05:54 PM. Reason: Deleted a. and b. - Do not apply here
Works like a charm, thanks!
The only problem I have now is Excel 2016 on Mac won't allow interaction with checkboxes/radiobuttons, etc.
When I open the spreadsheet on the Mac the checkbox won't check/uncheck - ran the macros via macro window and that's not the issue.
Maybe I'm not selecting something, maybe it's an extra step I need to be doing...I don't know, but it sure isn't intuitive.
It may not be a problem with the code. According to the last post in the following thread (posted about one week ago), many forms controls do not work on the MAC, and need a future update from Microsoft: http://answers.microsoft.com/en-us/m...60?db=5&auth=1
@LJMetzger, thank you so much for your support!
Sorry for not getting back sooner - wanted to post some sort of resolution.
I currently have a ticket out with Microsoft. They did a remote session with no success and the case is currently being escalated.
I'll post back as soon as it's resolved.
B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks