Calendar Control Linked Cell

[Marc Gendron]

Let's say my CalendarControl LinkedCell is F7. My macro selects column F and
inserts a column. This makes the LinkedCell property of my Calendar go to
#REF!. I would like to re-program it back to cell F7 after having inserted
my column. Of course, Calendar.LinkedCell = F7 would do it, ....but I get an
error message cause I cannot find the property "LinkedCell" for the Calendar
object.
How do I go about it ?

Thanks in advance for your kind help
Marc

 

[Dave Peterson]

Maybe...

With Worksheets("Sheet1")
.Calendar1.LinkedCell = .Range("F7").Address(external:=True)
End With

 

[Marc Gendron]

Thank you Dave, works perfectly !

Maybe...

With Worksheets("Sheet1")
.Calendar1.LinkedCell = .Range("F7").Address(external:=True)
End With