Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unsave or get a previously saved file - HELP PLEASE! | Excel Discussion (Misc queries) | |||
HOW TO RETRIVED THE PREVIOUSLY SAVED VERSION? | Excel Worksheet Functions | |||
how do i revert to previously saved program? | Excel Discussion (Misc queries) | |||
How do i revert to a previously saved excel file? SOS!!! | Excel Discussion (Misc queries) | |||
IS THERE ANYWAY TO RETRIEVE A PREVIOUSLY SAVED FILE ONCE IT HAS B. | Excel Discussion (Misc queries) |