reset option buttons
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?
|