rknight wrote:
[Quoted Text] > I have a calendar control on a worksheet (in a template file) and I
> need the calendar to display today's date when the workbook is opend.
>
> I've tried various forms of:
> Private Sub Workbook_Open()
> Sheet1 [Calendar1].Value = Now()
> End Sub
>
> and get various forms of error messages. Can someone please give me the
> correct code or is there something I can set in the property window
> without using VBA?
>
> thanks
> Ronnie
>
You could try Sheet1[Calendar1].Value = Format(Now, "dd mmm yyyy")
or something similar
Cheers Lynz
|