View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default How do I keep Calendar Control from closing?

Hi Roy,

If you insert a calendar control, it would normally remain visibile.

Do you have code associated with the calendar control? If so, post the
relevant code.


---
Regards,
Norman


"Roy Ringrose" wrote in message
...
I have used the Excel Calendar Control to put a calendar on my worksheet.
I
like the factor that I can select a date and it will put the date in a
specified cell. However I want to be able to keep the calendar active
(open)
on the worksheet without having to reopen it after i select the date, so I
could select other datesif desired. Is there a VBA that can be added that
does that?