mpolitte
01-07-2009, 10:25 AM
Gosh,
My first two posts were answered so well, I'm trying for a third. I now have a worksheet with column G (named "Type") defined as a list (values are 1-5). If the user selects a "Type" value of 1 (16 bit integer), in cell G2, I want to set cell H2 to "1", cell I2 to "1", and to disable/lock/or grey out cells K2 thru V2.
If the user sets cell G2 to "4 - a float" or to "5 - a string" I want to disable cell I2 and M2 thru V2. I think you get the picture, depending on the value of cell G# I want to set values in columns H# thru V# or disable them.
Here's the tricky part. I'll have to be able to handle a user selected range such that if the user selects G2-G10 and sets those cells to "1", I'll want to act as detailed above (H2-H10 must be set to 1, I2-I10 must be set to 1 etc.) for columns H2-H10 thru V2-V10.
As always, thanks for your expedient and accurate replies!
Maureen
My first two posts were answered so well, I'm trying for a third. I now have a worksheet with column G (named "Type") defined as a list (values are 1-5). If the user selects a "Type" value of 1 (16 bit integer), in cell G2, I want to set cell H2 to "1", cell I2 to "1", and to disable/lock/or grey out cells K2 thru V2.
If the user sets cell G2 to "4 - a float" or to "5 - a string" I want to disable cell I2 and M2 thru V2. I think you get the picture, depending on the value of cell G# I want to set values in columns H# thru V# or disable them.
Here's the tricky part. I'll have to be able to handle a user selected range such that if the user selects G2-G10 and sets those cells to "1", I'll want to act as detailed above (H2-H10 must be set to 1, I2-I10 must be set to 1 etc.) for columns H2-H10 thru V2-V10.
As always, thanks for your expedient and accurate replies!
Maureen