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

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

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

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

On Feb 28, 8:53 pm, 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
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.

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

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

"JP" wrote:

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

On Feb 28, 8:53 pm, 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
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.

hi
can you tell me how to go to the design mode? thank you so much :)

"tigoda" wrote:

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