I have an Excel 2003 file that contains a custom toolbar.  In Excel 2003 the
custom toolbar is displayed and I can just click the buttons on that toolbar
to run my macros.  When I open the file in Excel 2007 I can find no way to
display that custom toolbar.  In fact, the only way ...

other than entering 'yyyy-mm-dd' as date,
are there ways to enter dates "yyymmdd"
if I enter, for example, 20070101 and change the cell format to yyyymmdd
and the cell becomes lots of #.

Sup!
I always wonder if there is a way 2 make a list of names in ABC order.
Example: A1 to A30 has a list of names not in ABC order,  How do I make the
Colum A in ABC order without typing the names all over again?

In office we are now having xl 2007.
how do I create a personal workbook.?
I had a macro assigned to the menu bar how do it do it.
I had a "proper" macro pasted using VBA window and it was available for the

In Excel 2007, I create a shape in "Normal" view and set its width to
any value (e.g. to 15cm). Now I change to "Page Layout" view and guess
what... the width now shows up as something more than 16cm??!
(The width property as points in VBA changes accordingly.)

I have 4 workbooks:
- insertsheet AM
- insertsheet PM
- Dataprocessing

hi can anybody find a solution for the problem. I use office excel
2007 for 3 month without any problem. But now i cannot load excel
2007 ONLY. Other office software is loading correctly.
When i load excel 2007, a window appear with the following

I'm trying to use a database function to count the number of dates
that fall within a certain range, e.g. 2/1/2007 and 2/28/2007,
inclusive.
My criteria are

If I have a worksheet extending well in excess of the monitor screen and
want to print out only the part shown on the screen, how do I do it?

In my workbook, some formulas are like this:
=SUMPRODUCT(($E2<'sheet01'!$G$1:$G$500)*($F2>'sheet01'!$G$1:$G$500)*($C2='sheet01'!$E$1:$E$500)*($B2='sheet01'!$F$1:$F$500),'sheet01'!$J$1:$J$500)
'sheet01' is the name of one of my worksheets. It appears several time in
the worksheet.

Ok I have created a drop down menu on sheet2, which takes data from an entire
list of parts from sheet1..... then with advice from here, used the vlookup
command to also fill out the serial number associated with what I chose from
the drop down menu.  The problem is that each ...

I have designed and update query which resets fields to zero and an Onclick
event procedure as follows:
Private Sub RESET_ENTRIES_Click()
On Error GoTo Err_RESET_ENTRIES_Click

I've got a modelling spreadsheet comprising several worksheets - one
worksheet has a set of global parameters that I can adjust, another has a
set of statistical tables showing the impact of those parameters.
I want to be show the parameter worksheet on one monitor and the stats

If column T as a value equal to x then this row between Column B and Column
T need to font strikethrough and the pattern will be yellow. Complete this
format starting on row 5 to row 300.
Please help me complete this task using the Conditional Formatting.

My code reads one cell and through the options it locks or not others cells.
Im trying to extend my programming to all subsequent cells. How can I do it?
Like using "for" instruction?!?! Does anybody help me?
Private Sub Worksheet_Change(ByVal Target As Range)