Forum Discussion
Compound If statements
For that you shall to protect cells on which check-boxes have references, actually Master Data sheet.
SergeiBaklan I tried that.. but still spaced out the text without leave a check. Also, I added a Channel Partner and the =INDIRECT(B4) in cell B22 stopped working.. why is that?
Sorry, I don't know if that's possible. I'd suggest to ask as separate question (open new conversation).
SergeiBaklan so how am I suppose to "protect" check boxes so the User can tab to the field and use either the mouse or space bar to insert a check? Thanks!
You may define/edit it in Name Manager
but more easy way is to select the range and enter the name into Name box as it is done, for example, for MUFG
SergeiBaklan Where are the indirect values defined? I can't find Citi CCB anywhere in the spreadsheet. How do you look at those indirect values? I'll be adding new Channel Partners like Citi... how can this easily be done? Thank you for your help!
INDIRECT() doesn't work only for Citi, but this name isn't defined
If protect Master Data sheet (or part of it to which check boxes are linked) user can't change check box status, it'll be the message as