Hi All,

I have a calendar control object on my worksheet that is named
'calendar1' When i go into design mode it says that the embedded
control is 'MSCAL.Calendar.7'

I would like to set the 'autoload' property to TRUE on opening the
workbook but cant seem to get the coding right. Here's what l have
tried:

ActiveSheet.Shapes("Calendar1").AutoLoad = True

Can anybody help with this code please?

Regards

Michael Beckinsale