Quote:
|
The issue starts if the User selects what Section they belong to first.
|
Don't allow that.
Disable the option buttons until the check box is 'ticked'.
Quote:
|
The second issue is if the User selects the wrong Section and then tries to select the right Section and it causes the macro to error with a 'Run-time error '1004': Unable to set the Visible property of the Sheets class'. The workbook isn't protected and this one REALLY has me stuck.
|
The issue is with the array in the False portion of the previously selected option.
Rather than making one of the three sheets visible, you could make them all visible then hide the two that aren't required.
Maybe the attached will help.