Hi

I have created an excel file that has some cells that are locked and others
that are unlocked so that people can add data and submit the data to me. I
want to make it easy for them to clear on the data that they have entered so
they can reuse the file to put data in the next time they use it. Is there
way to create a button that will clear all the inputted data?


--
Thank-you!
Ruth

I believe it would be easier to create a Template and let users open a
workbook based on that Template.

Then they don't have to clear and re-use the same workbook.

They fill out the opened workbook, save as a unique name and send to you.

The Template never gets overwritten.


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 12:44:24 -0700, Ruth
wrote:

Hi

I have created an excel file that has some cells that are locked and others
that are unlocked so that people can add data and submit the data to me. I
want to make it easy for them to clear on the data that they have entered so
they can reuse the file to put data in the next time they use it. Is there
way to create a button that will clear all the inputted data?

This can be done, but it is somewhat complicated. Open the form, Click the
view tab, Click the Macros drop-down button on the far right, and click
Record Macros.
A dialog box will open, Change the name if you wish, click OK. Then proceed
to select the cells in sucession that you want to clear, and press delete in
each one. Be sure to do this to every cell. Cells that are together can all
be selected and deleted at the same time. Once you have cleared all of the
neccessary cells, click the Macros drop-down button again, and Select Stop
Recording.

This is where it gets confusing. If you are using Excel 2007, you will have
to find the Developer tab. You can turn this tab on in Excel Options under
category Popular, third check box from the top. If you are using an earlier
version, look for Insert Controls. From this box, select a User Form Button,
and then click somewhere on the spreadsheet. The button should appear. You
can move it later. Right click this button, and select Assign Macros. A
dialog box will appear, select your newly created macro, and hit OK. You can
change the name of this button by right clicking on it, and then left
clicking in the text area of the button.

Enter some text into the cells you wanted to be able to clear, and then try
out you new button.

"Ruth" wrote:

Hi

I have created an excel file that has some cells that are locked and others
that are unlocked so that people can add data and submit the data to me. I
want to make it easy for them to clear on the data that they have entered so
they can reuse the file to put data in the next time they use it. Is there
way to create a button that will clear all the inputted data?


--
Thank-you!
Ruth

Thank-you!
--
Thank-you!
Ruth


"Hendrix" wrote:

This can be done, but it is somewhat complicated. Open the form, Click the
view tab, Click the Macros drop-down button on the far right, and click
Record Macros.
A dialog box will open, Change the name if you wish, click OK. Then proceed
to select the cells in sucession that you want to clear, and press delete in
each one. Be sure to do this to every cell. Cells that are together can all
be selected and deleted at the same time. Once you have cleared all of the
neccessary cells, click the Macros drop-down button again, and Select Stop
Recording.

This is where it gets confusing. If you are using Excel 2007, you will have
to find the Developer tab. You can turn this tab on in Excel Options under
category Popular, third check box from the top. If you are using an earlier
version, look for Insert Controls. From this box, select a User Form Button,
and then click somewhere on the spreadsheet. The button should appear. You
can move it later. Right click this button, and select Assign Macros. A
dialog box will appear, select your newly created macro, and hit OK. You can
change the name of this button by right clicking on it, and then left
clicking in the text area of the button.

Enter some text into the cells you wanted to be able to clear, and then try
out you new button.

"Ruth" wrote:

Hi

I have created an excel file that has some cells that are locked and others
that are unlocked so that people can add data and submit the data to me. I
want to make it easy for them to clear on the data that they have entered so
they can reuse the file to put data in the next time they use it. Is there
way to create a button that will clear all the inputted data?


--
Thank-you!
Ruth