Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
clear specific cells in a form
Okay, I am not exactly an Excel genius. I have an Excel spreadsheet form that
is protected from editing in all cells except for the cells that require changing each time the form is used. For instance, A1 is protected and in the cell is the word Name and A2 is blank and unprotected so that the name can be entered. I do have the ability to unprotect the sheet. I am trying to come up with a way to clear the form of all the unprotected cells after the form is filled out. I hope that makes sense. Ron de Bruin has already sent assistance, but I think I am too stupid to understand. I would really need something specific for me to figure it out. Any help would be appreciated. -- bob |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
clear specific cells in a form
One way.
Hold down the CTRL key and select each of your unprotected cell. Then:- With all your cells still selected click Insert|Name|define and type a name for these cell, in this case MyCells Click OK Right click the sheet tab, view code and paste this in and run it to clear your range Sub clear() Range("mycells").ClearContents End Sub Mike "vdmbqb" wrote: Okay, I am not exactly an Excel genius. I have an Excel spreadsheet form that is protected from editing in all cells except for the cells that require changing each time the form is used. For instance, A1 is protected and in the cell is the word Name and A2 is blank and unprotected so that the name can be entered. I do have the ability to unprotect the sheet. I am trying to come up with a way to clear the form of all the unprotected cells after the form is filled out. I hope that makes sense. Ron de Bruin has already sent assistance, but I think I am too stupid to understand. I would really need something specific for me to figure it out. Any help would be appreciated. -- bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form. to ignore cells w/o value from calc from previous Form. | Excel Worksheet Functions | |||
Form Information transfer to a specific record | Excel Discussion (Misc queries) | |||
Is there a formula to clear the contents of a specific cell? | Excel Worksheet Functions | |||
How do I clear a column of data without clearing specific cells? | Excel Discussion (Misc queries) | |||
Hyperlink to specific Form in MSAccess | Excel Discussion (Misc queries) |