im not sure you can,
if there only simple shapes like boxes you could try drawing them in design
mode,

with design mode off they will be clickable but not selectable and right
click will do nothing

"ann" wrote:

also i would like to know how to disable rightclick with shapes...
i already disbabled rightclick in cells in the owrksheet but it doesn't seem
to work on shapes.. please help....

"ann" wrote:

Hi Tigoda,

I did your suggection but the shapes are still selectable using this method:
right click the object and select it again... they can even copy or delete
it...
is there any more ways you can suggest? thank you so much...

also I did the " do you mean right click format object Properties tab
dont move or resize with cells button" it didn't work either... please
help me out...
i really need this thing.. ive search so much but all i saw was to use sheet
protection..but even that i cannot use because i have a pivot table in the
sheet that requires refreshing...

i am using excel 2003.. if incase theres a version issue :) thank you so
much :)
your help is greatly appreciated.




"tigoda" wrote:

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 :)