Anyone know where to find the properties for the command button that is used
on worksheets?
This is for Excel 2000.
In particular I am looking for a tooltip property but I would like a list of

get the following message after generating a Macro
FILE IN USE.
PERSONAL.XLS IS LOCKED FOR EDITING
EggHeadCafe.com - .NET Developer Portal of Choice

I have purchased a new computer and have linked the email to AOL (imap/smtp).
I have no problem sending mail from outlook, however whenever someone reutrns
the message it goes to my Aol account. How do I correct it so that return
messages go to my office account

Good Evening,
I am having difficulty writing an If statement on my spreadsheet. What
I did was I have 2 spreadsheets that the first one has a master lister
of data. It is sorted by the following:

I have two different dated inventory lists.
Worksheet 1, O/H 4,622, starts on row 15, ends on row 3.095
Worksheet 2, O/H  4,611, starts on row 15, ends on row 3,089.
The header columns for each list are the same.

Where is the default document for excel when it is launched? I am
looking for the normal.dot of the excel world.
Symptom: When I open an excel document it launches excel.exe to a blank
grey screen.

Please help!  I am trying to create a formula that will give me a total of
the x's in a column.

I have a very strange problem on excel 2003 (11.6355.6360) SP1
When I create any formula (eg: SUM(A1:A10)) in a new document, it
works. If I change values in A1 -> A10 it is update in real time.
If I save the document, exit Excel, then reload the document (thus

I have a 3D column chart that shows the value as a data label. The
labels are appearing in the center of each bar. On the Format Data
Labels dialog box, no matter what option I select for horizontal &
vertical text alignment, the labels aren't moving. I'm using Excel

Is there a way to attach a particular formatting command to
double-click, rather than it editing the cell's contents?  For
instance, emboldening a row/column/cell just by double-clicking it?

I have a folder with a changing number of status reports in it. Each is
standardized and only contains one tab, "Status Report".
Each status report has a cell (always B10) categorizing what type it
is.

I have a shed-load of data that is grouped by day (eg. each date has a
corresponding number). I would like to be able to display the same data
but grouped by month and showing the daily data averaged for that month
to make it easier to analyse.

Is thier a formula to use to change hous and minutes, just into minutes ex:
01:30 (1 hour and 30 minutes) into 90 minutes. And how do you format the
cells.
Thank you

I copy and paste my credit card info into a spreadsheet so I can track my
expenses, when I paste the data in the dollar amounts show up as links. How
can I remove the link and just have them dollar amounts
thanks in advance

I am using the formula below to flag duplicate entries in a column of unique
numbers.  This works fine but I am also using Paste Links to carry the
information forward to the following month and where there is no information
to link to I am of course getting 0 which the the ...