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
>