Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable shape resizing or moving
Hi,
Iam currently working on a pivot report in excel. since i cannot use sheet protection to lock cells because the pivot needs to be refreshed, i found another way to make it uneditable... i used macro. now i have a slight problem... i dont know how to disable the resizing and moving of the shapes in the sheet. even rightclick doesnt seem to work with shapes.. any help is greatly appreciated :) thank you so much... i need to achieve the following: the shapes in the sheet cannot be move, cannot be sized..and if possible cannot be selected :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving and resizing the file window | Excel Discussion (Misc queries) | |||
disable a shape | Excel Programming | |||
Moving, Resizing a Cell Comment | Excel Programming | |||
resizing and moving chart elements | Charts and Charting in Excel | |||
Centering a Shape over a given cell when resizing | Excel Programming |