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:
You will need to replace "Sheet2" with the name of your hidden sheet.![]()
Worksheets("Sheet2").Range("B1").Value = _ Worksheets("Sheet2").Range("B1").Value + 1
You will also need to replace "B1" with the cell address of the cell you want the count.
HTH
Art
Bookmarks