Change object formula without selecting first ?
 

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

Change object formula without selecting first ?
 

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

NickHK

wrote in message
ups.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

Change object formula without selecting first ?
 

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

thnks,
halim

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

NickHK

wrote in message
ups.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