I have 45 questions that each has 9 option buttons to select from. Each option button returns a vlaue which is placed into a particular cell in another sheet.
What I want to do is re-set the option buttons to a particular button number on exit - so that each time you open the file it is set in a neutral state ready for the questions to be asked.
i have tried changing the settings in the properties tab for the options buttons but this does not hold after the initial selection is made.
Is there something else that I need to do - or do I need to put a code in the virtual basic part of the sheet to reset certain buttons ??
What I want to do is re-set the option buttons to a particular button number on exit - so that each time you open the file it is set in a neutral state ready for the questions to be asked.
i have tried changing the settings in the properties tab for the options buttons but this does not hold after the initial selection is made.
Is there something else that I need to do - or do I need to put a code in the virtual basic part of the sheet to reset certain buttons ??