It doesn't seem to be what you're looking for, but I created my own calendar
control that is native to Excel (actually a highly modified toolbar). It
looks and behaves very similar to the MonthView control. Perhaps you can use
it for part of what you need and use the logic behind it to develop the rest?

Greg


"anon" wrote:

Hi,

I'm aware this questions has been asked before in many forms, however
I am looking for something quite specific.

I am looking to create and Outlook style calendar within Excel. I
cannot use the Outlook calendar, nor can I use any type of add in (due
to distribution).

I need a calendar that a user can view monthly, and weekly (and
possibly drill into for a daily view dependant on the below).

The user will need to see a printable weekly view, and store around 10
- 15 entries per day. The entries will be populated from selections on
other sheets of the workbook and all will have a similar format (NAME,
ADDRESS, ADDRESS2, ADDRESS3, POSTCODE, TEL, CONTACT,NOTES).

I have tried creating a basic weekly layout that can hold 15 entries
per day, however I cannot get all of the information above to fit into
the entries without the week being too large to print on one page.
This is why I feel I may need a daily view, so the user can view and
print the basics, (perhaps NAME / POSTCODE) from the weekly view, and
drill in to the daily view to see the detail.

I would prefer to have a rolling calendar (ie never runs out), however
at a minimum would like 18 months if the rolling calendar would be too
complicated. I do not want to use lots of sheets, and do not want the
old entries deleted (however would like them hidden and only viewable
if required).

I am comfortable coding / creating a calendar once I can get my head
around the logistics of how it would look / work. Any help or
suggestions would be appreciated as I am fairly stuck at the moment.