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

--
msals2
-----------------------------------------------------------------------
msals22's Profile: http://www.excelforum.com/member.php...fo&userid=3090
View this thread: http://www.excelforum.com/showthread.php?threadid=55428

i ges that u can call ur command-buttons whitin ur buttonkode on sheets3

Call commandbutton-name

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