Problem with macro when used on Excel for Mac

Hi everyone,

I am having a problem with a database I made using a PC when used on a Mac. The database involves multiple userforms and pivot tables. After I first experienced a problem I looked into the userforms and realized Active-X buttons wouldn't work with Mac. So I changed the buttons to the form controls. Now, I am using this macro attached to a form control button to update the pivot tables:

Please Login or Register  to view this content.

That seems to be working fine. Now, I have a report sheet called "Summary Report" that has pivot tables using data from multiple sheets. I only wanted to have to use one set of slicers to control multiple tables from different sources, so I have a hidden sheet called "Master Slicers" that has all of the slicers and I have code written to the "Master Slicers" sheet that lets the user control all of the slicers just by clicking the ones on the "Summary Report" sheet. This code works just fine on my PC but when used on a Mac, it causes Excel to shut down. Here is that code:

Please Login or Register  to view this content.

SO, any ideas on why this would work on a PC but not a Mac? I don't have access to a Mac to test on so if anyone has a Mac with the most updated version of Excel I can send the whole file.

Update: after some research I've read that macros won't run on hidden sheets (which would be the "Master Slicers" sheet - BUT, I'm not sure why this would have worked on my PC if it's not possible at all. ANY insight at all would be appreciated.

Thank you!

Alison

Please use code tags around your code, so it retains its original formatting and for ease of copying.

Choose to edit your post, highlight all the code, press the # in the toolbar, then choose the save button at the bottom of your post.

The code should then have this format.

Please Login or Register  to view this content.

Thank you Alison.

Anyone with a Mac have any input on this?