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

Maybe...

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



Marc Gendron wrote:

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

Thank you Dave, works perfectly !

"Dave Peterson" wrote:

Maybe...

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



Marc Gendron wrote:

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