Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Button/Macro or Function has stopped working!
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Button/Macro or Function has stopped working!
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. -- 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP! Button/Macro or Function has stopped working!
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet macro stopped working! | Excel Discussion (Misc queries) | |||
Macro stopped working | Excel Discussion (Misc queries) | |||
macro stopped working after upgrade to 2007 | Excel Discussion (Misc queries) | |||
F4 Function Key stopped working | Excel Worksheet Functions | |||
Why have my Excel Macro Shortcuts stopped working? | Excel Worksheet Functions |