Change object formula without selecting first ?

[halimnurikhwan@yahoo.com]

Hi All,

I have a procedure that remove camera objects formula,
but still select them first before remove the formula ,,, is it
possible to remove em without select ?

Here is the sample code :
Activesheet.shapes("Pic1").select
selection.formula = ""

Any help will be appreciated,,,

Tks
Halim

[NickHK]

Have you tried Activesheet.shapes("Pic1").formula = ""

NickHK

<halimnurikhwan@yahoo.com> wrote in message
news:1155781283.244437.293380@74g2000cwt.googlegroups.com...
> Hi All,
>
> I have a procedure that remove camera objects formula,
> but still select them first before remove the formula ,,, is it
> possible to remove em without select ?
>
> Here is the sample code :
> Activesheet.shapes("Pic1").select
> selection.formula = ""
>
> Any help will be appreciated,,,
>
> Tks
> Halim
>

[halimnurikhwan@yahoo.com]

Hi Nick,
I've tried that but doesn't work ... ... ... ... ... ... ...

thnks,
halim

NickHK menuliskan:
> Have you tried Activesheet.shapes("Pic1").formula = ""
>
> NickHK
>
> <halimnurikhwan@yahoo.com> wrote in message
> news:1155781283.244437.293380@74g2000cwt.googlegroups.com...
> > Hi All,
> >
> > I have a procedure that remove camera objects formula,
> > but still select them first before remove the formula ,,, is it
> > possible to remove em without select ?
> >
> > Here is the sample code :
> > Activesheet.shapes("Pic1").select
> > selection.formula = ""
> >
> > Any help will be appreciated,,,
> >
> > Tks
> > Halim
> >