HELP! Button/Macro or Function has stopped working!

  • Thread starter Thread starter ikcizokm
  • Start date Start date
I

ikcizokm

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.
 
Many things -
the macro could be written to assume a specific cell is active,
it could be written to assume specific locations for information that have
changed.

More important would be to compare the layout of the data sheets or entry
sheets on the two workbooks and see if the are identical in terms of
location.

Better would be if you can read the code an trace through it - see what it
depends on. That should show you where it isn't finding what it need.

Does the code use
On Error Resume Next

this could be hiding the fact that the macro is hitting an error situation
and just quits without warning.

Post the code and perhaps someone can point out what is critical to correct
performance.
 
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.

(e-mail address removed)
 
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.
 
Back
Top