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



"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 >
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.




"tigoda" wrote:

> 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
>
>
>
> "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 >
> 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.
>
>
>
>
> "tigoda" wrote:
>
> > 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
> >
> >
> >
> > "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 <a...@discussions.microsoft.com> 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 >
> > 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.
> >
> >
> >
> >
> > "tigoda" wrote:
> >
> > > 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
> > >
> > >
> > >
> > > "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 <a...@discussions.microsoft.com> 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 >
> > > 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.
> > >
> > >
> > >
> > >
> > > "tigoda" wrote:
> > >
> > > > 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
> > > >
> > > >
> > > >
> > > > "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
> > > > >

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


On Feb 28, 10:06*pm, ann <a...@discussions.microsoft.com> wrote:
> 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 <a...@discussions.microsoft.com> 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 > Propertiestab >
> > > 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 usesheet
> > > protection..but even that i cannot use because i have a pivot table inthe
> > > sheet that requires refreshing...
>
> > > i am using excel 2003.. if incase theres a version issue thank you so
> > > much
> > > your help is greatly appreciated.- Hide quoted text -
>
> - Show quoted text -