I have a workbook which has a lot of complex shapes with macros assigned to them. These macros work fine when the worksheet is unprotected but some cease to work when protection is applied. The 'pointing finger' still appears but no action is taken as a result of clicking the mouse button.In some cases, the macro is only initiated from parts of the shape when protected. The ones which work can be varied by changing Zorder but I cannot get all of them to work at any one time. Any ideas?
The shapes need protection to prevent users messing up the worksheet. An alternative would be to disable the right mouse button for Drawingobjects. Any advice on how to do this? VBA solution would be fine.
The shapes need protection to prevent users messing up the worksheet. An alternative would be to disable the right mouse button for Drawingobjects. Any advice on how to do this? VBA solution would be fine.