Kindly help me how to apply codes in MS Excel 2007 using 10 command buttons to change color in specific cell
for example:
command button 1 = to appy color gray when being click and other buttons are disable = C5:C10 to D5:D10, C15:C17 to D15:D17, C23:C28 to D23:D28, to C47:C52 to D47:D52 and C62:C109 to D62:D109
command button2 = to appy color gray when being click and other buttons are disable = C15:C17 to D15:D17, C23:C28 to D23:D28, and C62:C109 to D62:D109
command button 3 = to appy color gray when being click and other buttons are disable = C57:C63 to D57:D63, C84:C110 to D84:D110, C220:C257 to D220:D257 and C309:C401 to D309:D401
command button 4 = to appy color gray when being click and other buttons are disable = C84:C110 to D84:D110, C220:C257 to D220:D257 and C309:C401 to D309:D401
.......................continue up to command button10
Bookmarks