Hi all - first post to this ng
I've just had my first play with Excel 2007 and (while I appreciate things
move on) I don't like the new ribbon interface.   In particular it's
irritating me that (having been an Excel user since 1994) I consider myself

Is there a way to prevent users from moving a file folder from one directory
to another?

How can I convert 3.5 hours to 3:30:00?

I am using InputBox to permit input to a routine and would like to limit the
alpha-numeric input to use uppercase characters only.
This is the line I am using:
NewClient = InputBox("SNAM of New Client (AAA123)")

Ok, I want to have Sheet1 display Employee Name (A1), Date of Hire (B1) and
Years of Service (C1). then in each row show the info like this example:
Employee Name,    Date of Hire,    Years of service
   Mike shmo,         4/10/2000,              8

Hi -
I;'m wondering if someone could give me a recommendation on this.  Can I
combine/pair/link two row labels together.
here is my example... I need to show both the acct# and acct. name in a

I have been using Excel for a specific purpose since about 1990 and every
version since. It is a spreadsheet with many embedded formulas which,
fortunately, have worked in all versions of Excel.
I am absolutely puzzled by the default behavior of Excel 2007 with regard to

HI, I need to find the "create list dialog box", in Excel 2007. I am doing a
school assignment and the book is Excel '2003'.
They want me to create a list range.
Thanks

I recently upgraded to Excel 2007. Do anyone know if there is a way to get
the old autofilter back? I really miss the the fast and easy old one. There
must be some kind of setting that disables the Pivot-ish autofilter that is
default in Excel 2007, right?

This is the first time I send the request to Office KB for the help in Excel.
My problem is to find out one formula which can  figure out the result which
I want. There are two sets of data.  The first set data is A, B, C, D, E, F,
G and H.  The second set data is A, A, G, G, G, G, ...

Hey guys
I've made a summary-file to collect data from several files in a
commen folder.
So far I've hardcoded my macro to pick up the datas from every singel-

Years ago, I had a handy little gizmo that allowed me to search Excel VBA
groups from within Excel. So, if I had a programming query I could find the
answers straight away without firing up a browser. Actually, I think the
point was that the gizmo fired up the broswer for me and ...

Can anyone explain to me why my spreadsheet sorts as follows. The cells are
formatted as text. This also happens with other similar data but I just cannot
see why. This does not seem to be either a test or numeric sort. In any
collating sequence I would expect all the T10's to be ...

I tried to highlight a column and use the Find/Replace to find "FAIL"
in the column and replace with "FAIL" in bold and red.  It reformatted
the entire cell contents, rather than just the single word.  Is there
a way to restrict the Replace action to just what is in the Find or

I have a music database when opened in Excel in has all info in rows and I
would like to add a few columns.
Want to Add       Col 1        Col 2            Col 3
Example: Row 1 America - 06/03/2007 - America - Here & Now [Disc 1]