SOLVED

Return excel VBA shapes to original position on Microsoft 365 MAC

Copper Contributor

Hello!

Please support my problem.

How to return excel VBA shapes to original position on MAC for Microsoft 365.

 

below Microsoft support center answer

This seems to be an unknown issue for Excel VBA o Mac, so I really recommend posting a discussion in the Excel community.Thus, Excel experts and Excel users can help you even more.

2 Replies
best response confirmed by YIYIYI (Copper Contributor)
Solution
I don't have a MAC.
You will need a macro to move the shapes.
The Macro would record the original position of the shapes and retain their locations.
In Windows that is the "TopLeftCell" of the shape.

The macro would loop thru all shapes on the sheet, match the shape name to the stored list of locations and then move the shape back to the original position.
Hope that helps.


'---
Nothing Left to Lose
Thank you for your cooperation.
It was difficult for me, but I was able to solve most of them.
Sincerely yours,
1 best response

Accepted Solutions
best response confirmed by YIYIYI (Copper Contributor)
Solution
I don't have a MAC.
You will need a macro to move the shapes.
The Macro would record the original position of the shapes and retain their locations.
In Windows that is the "TopLeftCell" of the shape.

The macro would loop thru all shapes on the sheet, match the shape name to the stored list of locations and then move the shape back to the original position.
Hope that helps.


'---
Nothing Left to Lose

View solution in original post