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 Exce...
- Oct 09, 2022I 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
Nothing_Left_to_Lose
Oct 09, 2022Brass Contributor
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
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
YIYIYI
Oct 09, 2022Copper Contributor
Thank you for your cooperation.
It was difficult for me, but I was able to solve most of them.
Sincerely yours,
It was difficult for me, but I was able to solve most of them.
Sincerely yours,