Reset Button
Hi,
You will need VBA, something like
Sub Reset()
Range("A1:A5","B3:B8","D45").ClearContents
End Sub
Add a button to the spreadsheet using View, Toolbars, Forms. Assign the the
macro to the button. By default this type of button does not print.
If this helps please click the Yes button
Cheers,
Shane Devenshire
"Raz" wrote:
hi,
I have an excell sheet (time-sheet) with about 90 cells with values in it. I
would like to have a reset button, When I press this button, I want some
cells (about 40) to become empty.
Also if possible i do not want the reset button to show up on the page when
i print my time sheet.
IS THIS POSSIBLE? please help. thanks in advance
|