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.
Excel Add-in: Mini Calendar and Date Picker
-
- GoldLounger
- Posts: 2640
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Excel Add-in: Mini Calendar and Date Picker
Regards,
John
John
-
- Administrator
- Posts: 79561
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- GoldLounger
- Posts: 2640
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: Excel Add-in: Mini Calendar and Date Picker
You do not have the required permissions to view the files attached to this post.
Regards,
John
John
-
- 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
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.
The video Mini Calendar Add-In for Excel and a little VBA code shows how to display the calendar from VBA.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 617
- Joined: 14 Nov 2012, 16:06
Re: Excel Add-in: Mini Calendar and Date Picker
Doubleclick in any cell:
You do not have the required permissions to view the files attached to this post.
-
- GoldLounger
- Posts: 2640
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: Excel Add-in: Mini Calendar and Date Picker
Hans/snb,
Thank you for the link and file.
Thank you for the link and file.
Regards,
John
John