Thread: Reset Button
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RAZ RAZ is offline
external usenet poster
 
Posts: 120
Default Reset Button

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