Thread: Reset Button
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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