This script will follow the active cell.
So when you click on a cell the shape will be next to the active cell.
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
I named my shape MY_Shape.
Modify name to your needs.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Modified 11/16/2018 7:29:50 AM EST
Shapes("My_Shape").Top = ActiveCell.Top
Shapes("My_Shape").Left = ActiveCell.Offset(, 1).Left
Is it possible to put this code in my Persional.XLSB so it will automatically run on all of my workbooks? I have a lot of worksheets in each workbook and i don't want to have to put this code in each sheet.