Forum Discussion

YIYIYI's avatar
YIYIYI
Copper Contributor
Oct 09, 2022
Solved

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

  • 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
    • YIYIYI's avatar
      YIYIYI
      Copper Contributor
      Thank you for your cooperation.
      It was difficult for me, but I was able to solve most of them.
      Sincerely yours,

Resources