I have a spreadsheet with option buttons from the control toolbox. Company
reps use this sheet to select various options to create a customer quote. Is
there any way, after a quote is generated, to have another button that will
reset these control buttons to a default state?

Hi!

Do these buttons have any code attached to them?

If they were from the Forms toolbar then all you have to do is clear the
linked cell(s) and the buttons will "reset". You can use a regular button
and give it a caption of Clear or Clear All and assign a macro to it that
clears the linked cell(s).

That's how I do it. I'm pretty much VBA illiterate!

Biff

"texicaliblues" wrote in message
...
I have a spreadsheet with option buttons from the control toolbox. Company
reps use this sheet to select various options to create a customer quote.
Is
there any way, after a quote is generated, to have another button that
will
reset these control buttons to a default state?

These buttons are from the control toolbar. They are grouped into steps
(i.e. select an option from step 1, step 2, etc.). The spreadsheet is
protected, so that nobody can accidentally mess up the formulas drawing from
the cells linked to the option buttons that derive the customer quote. What
I'm looking for is a way to reset selected options with one click. That is,
when a quote is done, the rep clicks "reset" and the quote form becomes blank
again. I, too, am VBA illiterate, but can copy and paste code. The problem
with assigning a macro to do this is that the spreadsheet is locked, so that
pressing Alt+F8 or whatever has no effect.

"Biff" wrote:

Hi!

Do these buttons have any code attached to them?

If they were from the Forms toolbar then all you have to do is clear the
linked cell(s) and the buttons will "reset". You can use a regular button
and give it a caption of Clear or Clear All and assign a macro to it that
clears the linked cell(s).

That's how I do it. I'm pretty much VBA illiterate!

Biff

"texicaliblues" wrote in message
...
I have a spreadsheet with option buttons from the control toolbox. Company
reps use this sheet to select various options to create a customer quote.
Is
there any way, after a quote is generated, to have another button that
will
reset these control buttons to a default state?