Spin Button only allow upwards of the previously saved value
 

Say a spin button is linked to a cell that has a value of 8 and the
shared workbook has just been saved by personA, is it possible that
when personB comes to use the spin button it will only allow them to go
to 9 or 10 etc but not down to 7.

It needs to be able to let person B move the value as high as they want
e.g 12, and be allowed to come down to the value that the workbook was
last saved at i.e 8.

Is this easily possible?

Any help greatly appreciated

Jason

Spin Button only allow upwards of the previously saved value
 

You would have to store the value when the workbook was saved somewhere, and
test against that. You would also have to set its base value at some point.

--
HTH

Bob Phillips

"jase" wrote in message
oups.com...
Say a spin button is linked to a cell that has a value of 8 and the
shared workbook has just been saved by personA, is it possible that
when personB comes to use the spin button it will only allow them to go
to 9 or 10 etc but not down to 7.

It needs to be able to let person B move the value as high as they want
e.g 12, and be allowed to come down to the value that the workbook was
last saved at i.e 8.

Is this easily possible?

Any help greatly appreciated

Jason