Shapes such as check boxes need to be selected to be modified.

activesheet.shapes("Check Box 1").select
selection.value = xlOn

I am with you I avoid selecting like the plague.

HTH

"Ward Germonpré" wrote:


Hi,

I don't understand why pasting a link is a method of the worksheet object
instead of the rangeobject.

According to the helpfiles, the paste methode takes either of 2 parameters:
destination or link

If you use destination, pasting as link is impossible.
If you use link=true, you cannot enter a destination and the link is pasted
to a cell which you have selected previously.

Avoiding selects is a fetish of mine. What other situations require
selecting ?


thx

Ward