View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Buritoking Buritoking is offline
external usenet poster
 
Posts: 1
Default Newbie Post - Clear All Button

Ok all I want to do is have a button that will clear all the cells in
workbook with multiple sheets. However there are only certain cell
that i want cleared. The workbook is for a stock/inventory system
have at work and I would only like to clear the cells with inpu
numbers in them. Should I protect all cells that are just words an
formulas (total quantity of stock items) and then leave the input cell
(where I enter the amount of individual stock items) unprotected an
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 b
thankful for any help thank you

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