Hi Julie,

There are a couple of suggestions he

http://www.contextures.com/xlDataVal08.html#Change



JulieD wrote:
Hi Debra

that's the problem then ... any work-arounds that you know of, short of
putting a "show options" button on the ws?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html