I recently made some modifications to the workbook template that Excel opens
when I start the program.  Prior to making these modifications, Excel would
remain open even if I closed all workbooks I had open, whether it was one or
ten, now the program closes if I have a single ...

I have a feeling that this is a simple thing...yet I have spent too much time
already trying to figure out this "simple" thing.
I have  a simple purchase order document set up in Excel 2007.  I have a
formula in the total cost column that essentially multiples the quantity by

I usually work in a couple of workbooks and have recently written a macro but
now when I open a second session of Excel I get a File in Use message-read
only.  I know there has to be a way to get rid of that so I can open the 2
sessions successfully. Please help/

I've been using this Workbook code for a while and it works great to
allow protected sheets and outline to work together.
Private Sub Workbook_Open()
   Dim mySheetNames As Variant

I would like the cell to say something different then #N/A when it cannot
find the exact value.  This is my current formula =IF(A22>0,
VLOOKUP(C22,UPC!A4:H1302,2,FALSE),"")

I have a table that lists any modifications to a test in 1 sheet by the
following criteria:
A         B                   C
LocID   Modification    TestType

I need some help writing a macro in visual basic.  I'm tring to give an
invoice number to each new invoice.  I don't want it to do it every time I
open the program though, I would like it to be done when I enter the customer
number into the field.  I'm not quite sure how to do ...

I wrote macro's yesterday and now everytime I open 2 workbooks the second one
gives me an error message of Read only.  I have tryed hiding the personal
workbook but I am still getting that error message.  Any ideas?
Thanks,

I have a spreadsheet that lists work orders. I was wondering if I could use
conditional formatting to flag any cells that are in past as of the date that
you open the spreadsheet.
Can this be done fairly easily?

I have a worksheet with hyperlinks to result files in one directory.
Somehow all the links were changed .
Some to
C:\Documents and Settings\MAM\Local Settings\Temporary Internet Files\OLK31\

Is there a way to count blank cells (within a specific column of data)
excluding the cells found in rows that are not populated?
ex.
             BH

In Excel 2003, is it possible to combine VLOOKUP and formatting so when
there is no match the cell is red?
Thanks in advance.

How can you turn off "Do you want to save changes you made to 'filename'.xls"
when closing a file, in Excel 2003, if you made no changes. Excel used to
recognize that no changes were made.

I have an invoice set up so I can scan a UPC and it pulls the item number,
however some of the items have the wrong bar code in the system.  I would
like to set it up so that if the UPC doesn't match exactly it doesn't pull
anything up, right now it pulls up the closest item ...

I received a workbook where the cell merge functions are disabled. This was
not done on purpose and the worksheet/workbook is NOT protected in any shape
or form. Orginally when the workbook was created it did allow merging.
All we know is the workbook was created in Office 2007 - ...