Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using button to clear contents | Excel Worksheet Functions | |||
Clear button | Excel Discussion (Misc queries) | |||
clear button | Excel Discussion (Misc queries) | |||
Clear Button | Excel Discussion (Misc queries) | |||
Newbie post - help with Subtotal please! | Excel Worksheet Functions |