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

"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

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

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





"Shane Devenshire" wrote:

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

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


"Mike H" wrote:

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

"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