Hi

I'm wondering if this is possible, and if so, how to do it.

My receptionist has to record an awful lot of statistics for every day
of the working week. What we've tradionally done is have a workbook
for each month of the year April - March, and within each workbook
there is a worksheet for every week. The workbook for January 2009,
for example, contains 5 sheets called "w/c 29.12.08", "w/c 05.01.09",
"w/c 12.01.09" and so on.

What I would like to do is have a workbook with 52 worksheets - one
for each week - and a front page with a calendar control, the idea
being that when the receptionist selects a date, the relevant
worksheet opens.

We use Excel 2000 and the object is to use Calendar Control 9.0 to
locate the relevant worksheet.

Can anyone advise, please; it would be much appreciated.

Steve