Excel 2002 SP3
Win XP Pro SP2
*Follow-up to: microsoft.public.excel*
Hi,

I have just purchased a PC with Windows Vista already installed, and have
installed Microsoft Office 2003 on it & registered it.
However, whenever I launch Excl I am confronted with a screen showing a
Microsoft Office End Users Licence Agreement which requires me to agree to

Hi to All,
I used the Tools > Customize command to create some custom button
buttons which I placed on an existing toolbar and assigned macros
to.   After closing Excel and reopening the buttons vanish every

when opening more than one excel file at a time, i do not get separate tabs
on the task bar even with ample room to do so.  instead, files are opened
within one excel tab and overlapped.  how do i change this to allow the
separate tabs on the task bar?

I have 3 columns in a spreadsheet
- Language (column A)
- Color (column B)
- Qty (column C)

I have this FREQUENCY formula in my srpeadsheet:
=FREQUENCY(P1:P40000;S1:S10)
If I autofilter the list, the formular will still display the results of all
rows. Is there away to get FREQUENCY only to count Filtered Rows? Or can the

I'm not sure how I can use left or right or trim on this, but any
suggestions?

I am trying to rate the performance based on a predetermined
percentage weight.
Example:
Bob has a 7% quality rate

Am using the code below to operate a combobox, but would like it to
read the information from the top line of the worksheet, currently is
reading down
Any help with this would be appreciated,

Is there a macro or formula that can be run to change the case of selected
cells from lower to higher case letters?
thank you for any help here
Jerry

Can anybody advise me how to determine whether a folder is exist and create
that folder if it is not available.
Thank you so much!!

I am trying to figure out Excel, and have not used it much.
What I need to do is put in a money amount, lets say $5 and the rate per
minute is $0.025 (2 1/2 cents) a minute.
I need the total minutes available with the total amount of money entered at

Can anyone point me to a free excel working timesheet to record employee
hours/breaks etc.
Thanks.
JM.

I am looking for formula to convert Annual stock return to a compounded
annualized return.
i have developed a formula that gives me the estimate annual return on a
stock of 22.0%. I want to convert it  to a compounded annual return. I

In deleting a macro my steps are:  Tools--Macro--Macro--  select Personal.XLS
in Macros Dialog Box.  Then Unhide Personal Workbook by choosing Windows on
the tool bar, then selecting unhide  on the drop down and clicking  O.K. to
the dialog box.    Then Tools---Macros--Macros ...