Hi!
I have a dashboard that brings in photos depending on the month selected from a drop down list. I have tested it on PC Excel 2013 and Mac Excel 2015 and it works perfectly. However one person I sent it to says it is not working on Mac Excel 2011. After they change the month on the drop down, all the dynamic numbers go blank and the photos don't change and they get a shape fill error. I don't have access to a Mac with Excel 2011 and I haven't had the chance to further question them about the errors. All I can suppose is that the error occurs at the bolded line below.
Also see attached for an approximation of my set up - though for some reason it is only running when I actually 'Play' from VB and not on Worksheet calculate. It behaves correctly in my working file.
Thank you!
Bookmarks