Link Checkboxes and Grey out the Check
 

I have a pricing sheet that has multiple check boxes on it which allows a
user to select certain options and devices and it totals them up for the
cost/unit.

I would like to link one or more check boxes together so if a user select a
certain device with a certain configuration of services he/she has to have
the correct service automaticaly checked off so they do not overlook them.

Link Checkboxes and Grey out the Check
 

New to this but i found a way that just may help, select your check box
that determines the first 'link' rt click and go to format_control,
'control' tab, and put in the cell link.(use an unused cell)

box 1 link to cell Z1
box 3 link to cell Z1
box 15 link to cell Z1

when you ckeck box 1, box 3 & 15 will check themselves and perform your
existing macro.

for all new links use a different blank cell

box 2 to Z2
bo12 to Z2
etc.

Let me know if this works for you.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=475066