Forum Discussion
YIYIYI
Oct 09, 2022Copper Contributor
Return excel VBA shapes to original position on Microsoft 365 MAC
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.
- 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
2 Replies
Sort By
- Nothing_Left_to_LoseBrass ContributorI 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- YIYIYICopper ContributorThank you for your cooperation.
It was difficult for me, but I was able to solve most of them.
Sincerely yours,