Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Button to clear all entries?
I am creating a fill in form in excel 2000. I am locking everything except
the cells I need filled in. I need a way to clear all entries in these cells after a form is completed and printed. This way the next user has a clean form to begin with. How can I do this...Thanks..Randy |
#2
|
|||
|
|||
Hi Randy
although this is possible an alternative would be to create your form as a template - this way you don't have to rely on people remembering to click buttons or do "save as" - a template will give them a blank form every time. To create a template, set up your form, with all the unlocked cells blank and then choose file /save as - and change files of type (down the bottom of the screen) to template - click OK (or save or whatever) - don't change the directory. and then close the form. Now to use it, choose from the menu, file / new - you should see your form listed, choose it and you'll have it ready to be filled in. Cheers JulieD "Randy" wrote in message ... I am creating a fill in form in excel 2000. I am locking everything except the cells I need filled in. I need a way to clear all entries in these cells after a form is completed and printed. This way the next user has a clean form to begin with. How can I do this...Thanks..Randy |
#3
|
|||
|
|||
There was similar question in .programming earlier, this was my response
there Sub ClearCells() Dim cell As Range With ActiveSheet For Each cell In .UsedRange If Not cell.Locked Then cell.ClearContents End If Next cell End With End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Randy" wrote in message ... I am creating a fill in form in excel 2000. I am locking everything except the cells I need filled in. I need a way to clear all entries in these cells after a form is completed and printed. This way the next user has a clean form to begin with. How can I do this...Thanks..Randy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear cell contents with a button | Excel Worksheet Functions | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
command button moves | Excel Discussion (Misc queries) | |||
How do I insert a 'clear all' button in excel? | Excel Worksheet Functions |