What I meant was that the

worksheets("sheet1").calculate

line of code should be somewhere else in your code, and outside the ws
selection change event sub.
Where have you tried including this bit of code?

Without knowing all the details of your process, userforms and any
associated module coding, it's a little difficult, but I would have
thought that you could introduce the line somewhere and force a
recalculation before the user is next presented with either a view of
the worksheet or userform.


Rgds



On Thu, 25 Aug 2005 19:15:46 GMT, "Jean-Pierre D via OfficeKB.com"
wrote:

Hi Richard,

still struggling....
Yes i tried that but it does not work because the recalculation code is in
the worksheet selection_change() sub....
If i use sheets("sheet1"). it will not execute the code entered in the
worksheet selection_change() part of the code because in sheet1 there is no
selection change at that point.

Any ideas?

Richard Buttrey wrote:
Hi richard,

[quoted text clipped - 4 lines]
(1) should be recalculated when a change is made on one of the multipage
userform !

Have you tried a

worksheets("sheet1").calculate

command somewhere in your coding?

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________