software

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 quot;resetquot;. 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

quot;texicalibluesquot; gt; wrote in message
...
gt;I have a spreadsheet with option buttons from the control toolbox. Company
gt; reps use this sheet to select various options to create a customer quote.
gt; Is
gt; there any way, after a quote is generated, to have another button that
gt; will
gt; 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 quot;resetquot; 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.

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Do these buttons have any code attached to them?
gt;
gt; If they were from the Forms toolbar then all you have to do is clear the
gt; linked cell(s) and the buttons will quot;resetquot;. You can use a regular button
gt; and give it a caption of Clear or Clear All and assign a macro to it that
gt; clears the linked cell(s).
gt;
gt; That's how I do it. I'm pretty much VBA illiterate!
gt;
gt; Biff
gt;
gt; quot;texicalibluesquot; gt; wrote in message
gt; ...
gt; gt;I have a spreadsheet with option buttons from the control toolbox. Company
gt; gt; reps use this sheet to select various options to create a customer quote.
gt; gt; Is
gt; gt; there any way, after a quote is generated, to have another button that
gt; gt; will
gt; gt; reset these control buttons to a default state?
gt;
gt;
gt;