Hey there! This is my first post, and I really need some help. I've got a workbook with multiple tabs, with macros that move data back and forth between the various tabs. I need to enable multiple users to update the tool, so I set the workbook as "shared". All of the macros still work with the exception of a few lines in one macro. :
Sheets("MSO Report").Select
ActiveSheet.Shapes.Range(Array("Rectangle 72", "Rectangle 73", "Rectangle 93")).Select
Selection.ShapeRange.IncrementLeft 528.25
This code is supposed to select three rectangles and move them to the right. I am getting "Run-time error '70': Permission denied". Is there another way to move these shapes? Any information would be greatly appreciated.
Sheets("MSO Report").Select
ActiveSheet.Shapes.Range(Array("Rectangle 72", "Rectangle 73", "Rectangle 93")).Select
Selection.ShapeRange.IncrementLeft 528.25
This code is supposed to select three rectangles and move them to the right. I am getting "Run-time error '70': Permission denied". Is there another way to move these shapes? Any information would be greatly appreciated.
