Excel template that lists each month's meetings w/ some detail
I'm looking for an Excel template that lists every month of the year with
room to list weekly, monthly and quarterly meetings, including some detail
for each meeting. Probably would need to be landscape oriented. The main
intent is to give the person using it an idea of upcoming meetings, the
intent of each and what prep is required.
...How do I make a 'box and whisker plot' graph in Microsoft Excel?
I am in Year 12 and am doing a stats assignment. The project states that i
MUST insert a box and whisker plot for some data, but i don't know how to do
this. Does anybody know?
Here are some sites on the topic of stats charting not just box and whisker.
Andy Pope, Microsoft MVP - Excel
"Year 12 student who needs help" &...hyperlinking to an item in Global Address List Options
I have had success linking via html from web page to opening a
specific contact record from Microsoft Outlook. I have done it like
However, my very large contact database also has people with basically
the same name, like John Smith. In the current "Address Card" view
inside Microsoft Outlook, one of the John Smith's is always sorted
first. If I enter
the first John Smith in the sort order is always opened.
However, I want to specify one of the other John Smith's....Computer Check Printing
Computer Checks Edit List is for a check run for one country (all the vendors
in that countrY), but the vendors from another country show up as zero
Any idea how to prevent this? It does not appear to be related to KB#
874437, as electronic payments are not used.
Thanks in advance.
...Error- Project is used by another user -Please select another proj
Please see the subject line, when im trying to open a particular project.
it gives me following error.
I checked the current users, there are no users. Apart from me.
There are some non PA users,i tried to remove them from activity.
inspite of me removing them from activity, im geting the same error.
There is a stranded user in PA000001 table. You need to clear this
> Please see the subject line, when im trying to open a particular project.
> it gives me following error.
> I che...Conditional Formatting w/ a List/Icons
I am trying to allow someone to select "Green", "Yellow" or "Red" from a list
and the cell to display a green/yellow/red icon appropriately. Or, if
possible, the user could just select the icon (instead of selecting text).
Is this possible?
Use Data Validation for the list. Type in Red, Yellow, Green as the list.
This give the user the list to select from.
Use Conditional Formatting for the fill part. Set three conditions, If Cell
Value-"Green" (select a green fill), etc..
If this helps, please remember to click yes.
"...Userform combobox matchrequired = True; error with no selection
I have a userform that includes a combobox which is optional for the user,
but if they do use it, they have to select one of the three values provided
(no creativity allowed).
This works fine if the user ignores the field, or if they make a selection.
They can even click the combobox 'arrow' to see the values and then click to
another part of the form without making a selection. They can tab through
controls including this one without any problem. All good.
However, a user may enter the field (mouseclick) thinking they might want to
make a selection, then decide again...hide/change color of selected row headings
Is it possible to hide the row heading numbers for
selected rows (i.e. rows 51 and greater) for just the
selected sheet? I'd like to have a color with no row
heading number appear that matches the fill color I select
for the adjacent cells.
Secondly, any ideas as to how I can prevent the user from
scolling further down than a certain point (i.e. row 51).
Thanks in advance.
Row headings are either on or off, you can't hide some. However, you
can achieve a similar effect by hiding *all* headings
(Tools/Options/General) and putting the numbers 1:51 in A1:A51.
to limit scro...Macro to apply alternate grey/white shading to selected paragraphs
I would like to do paragraph shading using grey shading alternately.
this is a sample text
This is another sample text
This is yet another sample text
This may be the last paragraph acquiring grey shading
This is the penultimate paragraph
This is the last paragraph
With these 6 paragraphs selected, I would like to run a macro which
applies grey shading alternately to the selected paragraphs, i.e. grey/
white (no shading) alternately.
Help is much appreciated. Thank you very much in advance.
Dim oRng As Range
For i = 2 T...OL2003 Master Category List
Anyone know where the master category list is hiding these
days. In 2002 it was hkcu\software\microsoft\office\10
Any help would be appreciated.
change 10 to 11. It won't exist unless the user has added something to
it and like Outlook 2002 it's a Unicode list so the value is a binary
and not a string.
[MVP - Outlook]
Author: Absolute Beginners Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
"Dan" <firstname.lastname@example.org...Smart List
This is a multi-part message in MIME format.
BlankIs there any way to get a report in smart list that includes the =
serial numbers using inventory transactions or sales transcations? I =
have version 7.0
charset="Wind...zoom bitmap in CStatic Picture Control
I show an image with SetBitmap of my CStatic Picture Control in a dialog. My
CStatic window's size is unsizable, so I let the image be shown centred. But
each image is dimensioned differently. How can I zoom the image in my
m_stcPic.GetWindowRect(rect); // mein CStatic Picture Control
double fx = (double)image.GetWidth() / (double)rect.Width();
double fy = (double)image.GetHeight() / (double)rect.Height();
HBITMAP m_bitmap = image.MakeBitmap();
if (fx > fy)
// use fx to zoom
// use fy to zoom
In ...Exchange 2K: Controlling incoming email formats....
AFAIK (and correct me if I am wrong), Exchange natively only lets you
control message formats for messages that are downloaded to POP\IMAP
For security reasons, I would like Exchange to convert all incoming\outgoing
email from\to external domains, as well as INTRA-domain email , to plain
text format. In other words, I do not want to see anymore html email on my
server going in and out, just plain text.
Is there a setting for this for Exchange to handle this natively? If not,
what (if any) 3rd party solutions are out there for this?
Here's the Re...How to select other random cells
I have a 2 part question. I want to have a 1 question survey randomly filled
out by 200 people. Column A lists the 1 questions. Columun b has ABCDE
listed in cells B6 to b10. I would like 200 samples in columns c, d, e, etc.
How do I set this up so that they randomly Coose B6 to B 10.
Second part. On another spreadsheet, I have a similar situation, but the
user has 10 answers to select from and I want them to randomly select all
that apply. How would I do this? Thanks!
...drop down boxes #14
Is it possible to change to fonts or fill colours of a cell containing a drop
Any help would be much appreciated
If you made the drop down box using validation then you should be able to
change the colors just like any other cell. If you used a combo box from the
control toolbar, then you've got to right click and go to properties.
> Is it possible to change to fonts or fill colours of a cell containing a drop
> down box?
> Any help would be much appreciated
Thanks for your reply....select worksheet
There is probably a very easy answer to this question, but if you don't know
I want a specific worksheet to open when I open the workbook. Is there
specific code that needs to be written or can I do it in the worksheet
properties? The help files seem to be vague on this issue. Thank you for any
...can i create a modalless dialog Box in the worker thread.
hi guys, is it possible to create a modalless dialog box in the worker
thread, actually we have try this but we got error that is" you cannot
create object with new operator in the worker thread " but i don't know
what is the actual reason behind this. actually i am trying to create
a modalless dialog box from main dialog box and i want to perform
openGL programing on both the dialog box in such a manner so that they
do not collapse or crash each other because at one time only one
rendering device context should reside in the memory if we want to
create more then one device con...Message box when DOB meets certain criteria
I am a relative novice to the ways of Access, I am currently setting up a
database in Access 2003.
I have a form field (DOB) that if the date of birth entered makes the person
between 2 and 16 years old I would like a message box to appear notifying the
user (and be able to turn it off). Similarly if an existing record is opened
and a child has it's second birthday I would also like the message to appear..
.I have posted a similar request and have got thus far:
Private Sub DOB_BeforeUpdate(Cancel As Integer)
If DateAdd("yyyy", 2, [DOB]) > Date Or Date...Check if latest updates installed
Is there a way to check, remotely, if the latest Windows updates have been
installed on a computer?
1. Connect via RDP and run Windows Update from Start Menu.
2. Download and run MBSA.
3. Use third party utility (www.shavlik.com)
"JohnB" <email@example.com> wrote in message
> Is there a way to check, remotely, if the latest Windows updates have been
> installed on a computer?
Sorry forgot to mention:
1a. WSUS has also reporting capabilities
1b. SCCM and...My spell check keeps switching off in word 2007
Every time i try and write a document the spell checking keeps switching off.
Depsite me switching it back on, it changes back as soon as I start typing. I
have tried uninstalling and reinstalling to no avail.
Can anyone help cos this is driving me potty??
Is the correct language applied to text? See also
Microsoft Word MVP
"geordielass86" <firstname.lastname@example.org> wrote in message
> Every time i try an...Auto check email address
When typing in the TO: box, a drop-down list pops up with
a list of names to choose from.
Is there any way to edit the names in this list?
Thanks for your help.
I don't think there is. All that is is a list of recent addresses that you
used. Same concept as "My Recent Documents" in Windows. I am wondering now
if there is a way to reset it?
"Pasbrig" <email@example.com> wrote in message
> When typing in the TO: box, a drop-down list pops up with
> a list of names to choose from.
&g...Outlook Express Spell Check
When trying to spell check I get the error message" an
error has occurred while the spelling was being
checked.". I have XP-Home.
Is there a fix for this.
Microsoft offers no fix for the problem in the knowledge
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Intel PCs. For Outlook Express (OE) support try posting in one of
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
Does any people know it is possible to create box-and-
whisker chart via Excel? If yes, how to do? Thanks a lot!
Jon Peltier has some instructions on his web site:
Bill Li wrote:
> Hello all,
> Does any people know it is possible to create box-and-
> whisker chart via Excel? If yes, how to do? Thanks a lot!
> Best Regards
Excel FAQ, Tips & Book List
...CListCtrl updates the whole control instead of just a single raw
I use an object of CListCtrl in my view. My problem is that whenevr it
updates, it does it to the whole screen instead of doing it just to the last
Can someone advise please?
"Greg" <firstname.lastname@example.org> wrote in message
> Hi All,
> I use an object of CListCtrl in my view. My problem is that whenevr it
> updates, it does it to the whole screen instead of doing it just to the
The last what?
> Can someone advise please?
> I. Greg
>...Length-limits in Edit-boxes dynamically created in MFC...
Hi! I have found an excellent class by a fellow named Marcel Scherpenisse.
One problem is that when I use this class to create edit-boxes, the string
length is limited to the actual size of the text box. Unfortunately, I do
not really know how this class works, but it uses DDX_Text to transfer the
data between a CString and the edit control. I have tried to send the
message EM_SETLIMITTEXT to what I believe is the control, but no effect.
You can find the class here:
I've been trying to contact mr. Scherpenisse, to no avail, so I thought...