disable shape resizing or moving

  • Thread starter Thread starter ann
  • Start date Start date
A

ann

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 :)
 
you say even right click isn’t working,

do you mean right click > format object > Properties tab > don’t 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
 
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 >
don’t 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.
 
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....
 
You could protect the worksheet (manually, or by VBA code) then use
some macro code that would temporarily unprotect the sheet just to
refresh the pivot table. Hey, this is the programming newsgroup after
all :-)

Here's a thread on another board showing just how to do that:
http://tinyurl.com/2pobmj

HTH,
JP
 
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
 
I am afraid that the pivot requires more than refreshing.. because theres a
lot of data there..its a complete report :(
but i will try your suggestion and see if it will work. thank you very much
for your help.. but wait do you know how to disable right click and disable
moving shapes in excel???
thank you so much
 
Right-click the sheet tab, select "View Code", paste this in:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel
As Boolean)
Cancel = True
End Sub

This will disable right clicking in the worksheet space only (i.e. you
can still right click on the menus).


HTH,
JP
 
Back
Top