I am working with a client who has run into a problem running a macro m
firm put together. The client is using Excel 97 and we are using Exce
2000. At this point, my information is vague, but the client state
that there was a "compile error" (I need to check what specific erro
this is).

All I know at this point is that the spreadsheet was built in Exce
2000 and the error occured while running on Excel 97.

The Macro that failed is based on a named cell which uses Dat
Validation. It is a Yes/No list. From what I can see, the cod
actually puts a "Yes" into the cell regardless of what the user doe
and runs a routine.

Is there a chance that the data validation assigned to this cell is no
combatible with Excel 97??

I now my details are vague. Currently I am looking to run this o
Excel 97 to check for myself.

Thank-yo

--
ExcelMonke
-----------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522
View this thread: http://www.excelforum.com/showthread.php?threadid=26235