How do I insert a calendar at the top of worksheet?
 

I would like to insert a small calendar in the top right corner of a worksheet.

jml, see if this will do what you want,

http://www.fontstuff.com/vba/vbatut07.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"jml" wrote in message
...
I would like to insert a small calendar in the top right corner of a
worksheet.

There's a very useful Calendar Control, an ActiveX, that has shipped with
Excel ever since Excel 97. In older versions you had to specify that you
wanted it during the installation routine; now (say, XL 2002 and later) I
_believe_ that it's installed by default. To get at it, assuming that it's
been installed, choose View | Toolbars | Control Toolbox. The final icon in
that toolbar has an image of a hammer, a spanner wrench and an ellipsis.
Click on that icon to get More Controls. You should find one (they're listed
in alpha order) named Calendar Control; its version number depends on the
Excel version you're running. Click it and when you move your mouse pointer
back over the worksheet it will turn to a crosshairs. Click the mouse button
and drag down and right to locate the calendar.

It's a little tricky to work with this control, but once you've got it
figured out it's a splendid way for users to specify dates. A client of
mine, a hospital, has been using it to schedule rooms for the past six
years, without a problem. No, not even a user error -- it's that easy to
use.

C^2
Conrad Carlberg

"jml" wrote in message
...
I would like to insert a small calendar in the top right corner of a
worksheet.