If the command buttons on sheets 1 and 2 trigger macros to reset the cells,
then you can add a command button on sheet 3 to trigger all the macros.

"msals22" wrote:


I have 3 sheets in my workbook...sheet 1 has 2 command buttons that
resets cells, sheet 2 has 2 command buttons that resets cells, and
sheet 3 summarizes values in sheets 1 and 2. I would like to put a
command button in sheet 3 that when clicked, clicks the command buttons
on sheets 1 and 2 to reset all values. Any ideas?


--
msals22
------------------------------------------------------------------------
msals22's Profile: http://www.excelforum.com/member.php...o&userid=30908
View this thread: http://www.excelforum.com/showthread...hreadid=554289