Excel Add-in: Mini Calendar and Date Picker

jstevens
GoldLounger
Posts: 2640
Joined: 26 Jan 2010, 16:31
Location: Southern California

Excel Add-in: Mini Calendar and Date Picker

Post by jstevens »

I'm looking for a properties list for the mini calendar. The properties list would be similar to a Userform.

After installing the add-in I can see a small calendar on the worksheet. The object can be hidden with: ActiveSheet.Shapes("Add-in 1").Visible = False.
Regards,
John

User avatar
HansV
Administrator
Posts: 79561
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Add-in: Mini Calendar and Date Picker

Post by HansV »

Which add-in is this?
Best wishes,
Hans

jstevens
GoldLounger
Posts: 2640
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Excel Add-in: Mini Calendar and Date Picker

Post by jstevens »

Hans,
el_addin.jpg
You do not have the required permissions to view the files attached to this post.
Regards,
John

User avatar
HansV
Administrator
Posts: 79561
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Add-in: Mini Calendar and Date Picker

Post by HansV »

I don't think you can access the calendar's properties - to VBA it's just a shape.
The video Mini Calendar Add-In for Excel and a little VBA code shows how to display the calendar from VBA.
Best wishes,
Hans

snb
5StarLounger
Posts: 617
Joined: 14 Nov 2012, 16:06

Re: Excel Add-in: Mini Calendar and Date Picker

Post by snb »

Doubleclick in any cell:
You do not have the required permissions to view the files attached to this post.

jstevens
GoldLounger
Posts: 2640
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Excel Add-in: Mini Calendar and Date Picker

Post by jstevens »

Hans/snb,

Thank you for the link and file.
Regards,
John