Hi Tilly,
when you draw you button on the top sheet it asks you to assing a
macro, like "Button1_click", click NEW
In the VBA editor window that thn open copy in the following:
Code:
--------------------
Worksheets("Sheet2").Range("B1").Value = _
Worksheets("Sheet2").Range("B1").Value + 1
--------------------
You will need to replace "Sheet2" with the name of your hidden sheet.
You will also need to replace "B1" with the cell address of the cell
you want the count.
HTH
Art
--
HiArt
------------------------------------------------------------------------
HiArt's Profile:
http://www.excelforum.com/member.php...o&userid=19953
View this thread:
http://www.excelforum.com/showthread...hreadid=472028