Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks, Harald and Tom.
I'll probably go with Harald's suggestion - remove the checkboxes and use some other visual indicator. I wanted to retain a consistent appearance within the table of checkboxes (where a user selects one or more practices, via the checkboxes, that apply to up to 10 distinct land areas), but for these particular 2 practices, the user provides input elsewhere in the workbook that amounts to selecting the practice, and I want to report it somehow in the checkbox table. Not sure if this makes sense without going into great, boring detail. Anyway, imho the appearance of the grayed-out checkboxes can be confusing to an audience who isn't used to seeing them. Thanks again for your input. Yeah....recursive code without end does slow things down a bit! <duh -Scott "Harald Staff" wrote in message ... Oops. Thanks Tom. I missed the "I have 20 checkboxes that I do not want users to be able to change" part, probably because it's meaningless to me. Imo those boxes shouldn't be there. But enabled = false is definitely a good option if "this is for the big guys and you're definitely not one of them" is an important message for the users. Best wishes Harald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple Checkbox Message Code | Excel Discussion (Misc queries) | |||
A VBA code that clicks a checkbox | Excel Programming | |||
Checkbox Code | Excel Programming | |||
testing the state of a checkbox in vba code | Excel Programming | |||
Rob Bovey's Code Cleaner makes file larger. Why? | Excel Programming |