Hi Max

sorry i don't have ver 97 on my machine anymore to test against ... email me
direct (julied_ng at hcts dot net dot au) and we can walk through the macro
and see what's going on ....

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Max" wrote in message
...
"JulieD" wrote
try the refresh button it might be cached ...
the file is at the end of the Excel bit called
SAMPLE WORKBOOK Dependent data validation lists using VBA.

Thanks, Julie. Got the file now.
But I seem to have a problem getting it up (macros are enabled).
Does it work in Excel 97 (my version) ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----