Reset Button

  • Thread starter Thread starter Raz
  • Start date Start date
R

Raz

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
 
Hi,

That's certainly possible but you can't have a macro that says

if button 1 is pressed delete about 40 numbers

delete about 40 numbers

end if

Please be more specific.

Mike
 
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
 
thanks, but i have never used a macro before, please explain in a little detail
here is exactly how I want it.

need the button in cell T4 and
need these cells (below) to reset to empty when button clicked

B8 to T8
B9 to T9
B11 to T11
B12 to T12
B14 to T14
B15 to T15
B17 to T18
............
...........
B51 to T51


Thanks again
 
thanks, but i have never used a macro before, please explain in a little detail
here is exactly how I want it.

need the button in cell T4 and
need these cells (below) to reset to empty when button clicked

B8 to T8
B9 to T9
B11 to T11
B12 to T12
B14 to T14
B15 to T15
B17 to T18
............
...........
B51 to T51


Thanks again
 
Back
Top