I'm at a loss with this one. I have a workbook with a number of sheets, and on some of those sheets are a lot of shapes. These are used to create a 3D representation of a Rubik's cube. There are macros running things behind the scenes. When I use this workbook on any windows machine running any version of excel (from 2010 up to 2021), everything displays perfectly. Here is an example:
Note that all the lines look normal and it looks like a cube (albeit a strange one
).
When it runs on a mac (running Excel 16), this is what happens:
However, on the three sheets where these shapes are setup, it is happening on two of the sheets only. The other sheet displays normally.
The obvious assumption would be that the vba code is somehow different on that page, but it's the same (I wrote one set of code and copied it across to other pages [and adjusted where need be]. I went through it in detail today just to see if I could find any differences, but I can't. All variables are declared, and relevant lines of code are the same.
My next thought was whether the actual shapes were somehow named differently, or had different properties. But everything seems fine there as well.
For reference, the shapes and columns/rows etc are locked and the sheets are protected, so there's no way it's because somehow a column width was changed or something. The properties of the shapes are set to the following:
I wondered whether I may need to alter things to "don't move", so on one sheet only, I changed the properties to this:
Very strangely, it made no difference, and in fact, the sheet where the images display correctly has the properties set to "move and size".
I am really at the end of my ability to figure this out; I'm kind of annoyed because (as usual...) this is only an issue on Mac computers and I wasn't expecting it.
Does anyone have any ideas about what I need to do to make these things display properly on a Mac?
Thankyou.
Note that all the lines look normal and it looks like a cube (albeit a strange one
).When it runs on a mac (running Excel 16), this is what happens:
However, on the three sheets where these shapes are setup, it is happening on two of the sheets only. The other sheet displays normally.
The obvious assumption would be that the vba code is somehow different on that page, but it's the same (I wrote one set of code and copied it across to other pages [and adjusted where need be]. I went through it in detail today just to see if I could find any differences, but I can't. All variables are declared, and relevant lines of code are the same.
My next thought was whether the actual shapes were somehow named differently, or had different properties. But everything seems fine there as well.
For reference, the shapes and columns/rows etc are locked and the sheets are protected, so there's no way it's because somehow a column width was changed or something. The properties of the shapes are set to the following:
I wondered whether I may need to alter things to "don't move", so on one sheet only, I changed the properties to this:
Very strangely, it made no difference, and in fact, the sheet where the images display correctly has the properties set to "move and size".
I am really at the end of my ability to figure this out; I'm kind of annoyed because (as usual...) this is only an issue on Mac computers and I wasn't expecting it.
Does anyone have any ideas about what I need to do to make these things display properly on a Mac?
Thankyou.
