one way

place a button from the forms menu on a sheet and attach this code to it

Sub Macro1()

Range("H4,J4:J20,C17,E25,H16,F12").Select
Selection.ClearContents

End Sub

the actual range you use would be the cells you want to delete. The simplest
way to do it is actually select the cells while recording a macro


"Buritoking " wrote in message
...
Ok all I want to do is have a button that will clear all the cells in a
workbook with multiple sheets. However there are only certain cells
that i want cleared. The workbook is for a stock/inventory system I
have at work and I would only like to clear the cells with input
numbers in them. Should I protect all cells that are just words and
formulas (total quantity of stock items) and then leave the input cells
(where I enter the amount of individual stock items) unprotected and
then have a button that just clears the unprotected cells?

If there is code for a button that will do this I would very much be
thankful for any help thank you.


---
Message posted from http://www.ExcelForum.com/