Hi,

One of my users have a workbook originaly designed in
excel 97 that have different ranges, in each of thoses
ranges the cells contain a RAND(). when run on excel 97
it work perfectly but in XP it give a error
1004 "calculate method of range class failed" the cells
and the sheets are not protected and the range have only
the "hidden" option On, (I tried to deactivate it and get
the same results).

I am able to get the value in the range.cells selected
but cannot calculate it, must be a new protection feature
of XP I do not know...

Any help would be appreciate

Many Thanks