So basically, I have a number of checkboxes which link to different cells. What I want to do now is add a kind of 'master' checkbox, which can check/uncheck all of (or groups of) the 'child' checkboxes.
I have a feeling this is only going to be achievable via a macro, but I'm reluctant to use one in this particular instance, so if there's another solution that would be awesome.
Hi brokenbiscuits,
No solution that isn't VBA comes to mind on this question. You would need a formula behind each individual linked cell pointing to the master checkbox cell. This would keep them from being selected individually.
Time to learn VBA? A Event Macro behind the worksheet using Change or SelectionChange would be my guess.
Look at http://www.cpearson.com/excel/Events.aspx and then find the "Intersect" in the code.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Yeah, I know how I could do this with VBA, but my vision with this particular workbook, due to the preferences of the audience, is for it to be macro-free.
So I was just asking more in hope than expectation!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks