If anyone is interest, the macro was applying an advanced filter and the
definition of the defined name Criteria was screwed up - it didn't include
the cell where the name was entered, only the column headers.

--
Regards,
Tom Ogilvy

Tom Ogilvy wrote in message
...
don't post the workbook to the newsgroup.

If you want to send it to me (zip it if it is large),
I can take a look at it.



--
Regards,
Tom Ogilvy

ikcizokm wrote in message
...
OK... so I'm helping a friend with an Excel problem and have hit a snag.
A store has a list of "registered" customers. The original spreadsheet
was programmed by an employee who no longer works there. There is a
button in the workbook labeled LOCATE. What's supposed to happen is if
you type a customer name (ex. JOHNSON*), press enter, and then click
the LOCATE button, the workbook should show all the items that customer
buys on a regular basis.

Here's the snag: the original workbook performs this function properly.
However, a newer version of the workbook WAS performing correctly until
recently, but now does not. The users at the store are not very
PC-literate and are unsure what they may have done to suddenly cause
this to stop working. After comparing the original to the new workbook,
I'm stumped, too.

I checked out the macros in the original workbook and compared the
LOCATE macro in the updated workbook and they're identical. My question
is: what else could cause this function to cease working?

Thanks in advance.