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:
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:
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
Bookmarks