Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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.
|
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert comment in protected worksheet | Excel Worksheet Functions | |||
Insert worksheet is greyed out, is there an option to turn it on? | Excel Worksheet Functions | |||
insert picture | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |