Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
row disabling upon check box click
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
row disabling upon check box click
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. "Don M" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Disabling click and right-click on the Picture I inserted in an Excel document | Excel Worksheet Functions | |||
Disabling Macro-Virus check | Excel Programming | |||
Disabling Macro-Virus check | Excel Programming | |||
Disabling Right Click Menu | Excel Programming |