You hadn't got the Selection_Change code in Sheet1 code module.
In future, I'd avoid naming objects with cell references (Cmd1, Cmd2 etc) so I've renamed them CmdB1 & CmdB2.
You hadn't got the Selection_Change code in Sheet1 code module.
In future, I'd avoid naming objects with cell references (Cmd1, Cmd2 etc) so I've renamed them CmdB1 & CmdB2.
Semper in excretia sumus; solum profundum variat.