disable shape resizing or moving
you say even right click isnt working,
do you mean right click format object Properties tab dont move or
resize with cells button
if not, give it go,
as for making them un-selectable, a quick and dirty way I use to create a
new sub that just says
sub no_move()
end sub
And assign the shapes to this macro, it will make the shapes un-selectable
and unmoveable unless you use the little cursor tool on the drawing tool bar
"ann" wrote:
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 :)
|