column reset button to default column value to 0

[howster]

Hi Guys,
How would i implement a reset button that sets all the values in eg C1:C10 to 0 and also how would I implement a calculate button that is positioned at C11 to add the values of C1:C10 and stick the total in say D10?

Thanks

[watersev]

hi, Howster, please check attachment, click the buttons on the Sheet1

[howster]

THANK YOU SOOOOOO MUCH! Perfect! Just gotta find where the code in the macro now is Excel 2007 has me all confussssed and muxed up.

[howster]

Hi Guys,
Gotta change something small:
In

Please Login or Register  to view this content.

How to I amend the above to omit the [f136] part. I just want the range f1:f135 set to zero for another issue

THANKS

[watersev]

please amend the posted code under Forum rules.

You need to put it this way:

Please Login or Register  to view this content.

[howster]

Thanks again!

This worked perfect:

Please Login or Register  to view this content.

Last question, Is it possible to run a macro in a protected sheet. I dont want the user corrupting some formulaes in the cells.
Thanks

[watersev]

to protect sheet:

Please Login or Register  to view this content.

to unprotect sheet:

Please Login or Register  to view this content.