Reset values

[eedie]

Hi,


I have a row that the user enter data from validation values in a drop down box. Calculations take place and we have a Total. The worksheet is protected as well as the formulas.

How can I reset the users selected values so that they can start with a fresh sheet.

Cheers

 

[SkipVought]

Hi,

What do you mean by "reset"?

Display a set of initial values or CLEAR each input cell?

Are you using a macro? If so please post the code.

Skip,
[sub]
[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![/sub]

 

[AnotherHiggins]

Like Skip, I'm not sure exactly what you want to do.

But you might want to consider using a TEMPLATE. That way a user can open the template and it will be blank. They can enter data and save it, but the next user can just open the template to have a 'blank' sheet again.


Mornin', Skip
[tt]
^ ^
| |
| \
| OJ
|
Coffee
[/tt]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.