row disabling upon check box click

[Don M]

I have a spread sheet (temporary, otherwise I'd make something nicer)
that tracks history of certain entries. My idea is that if I have a
check box in the "A" column at the beginning of the row, I could click
that check box to signify "case completed" and it would make that row
readonly and possibly shaded (much like disabled radio button text in a
form). How would one code that?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Jared]

Don

In the 'checkbox_click()' code module, you need to write code that protects
the worksheet and protects each cell in the row that you wish to be disabled.
You can then use the colorindex property to change the color of cells in that
row, so the row will appear disabled.