User Form - Exception Occurred

**Riggers** · 09-20-2011, 03:29 AM

I have a user form with 48 checkboxes on it. To my knowledge I've not made any changes to it and it was working ok yesterday but now when I click some of the checkboxes it causes an 'Exception Occurred' error to pop up. To try and troubleshoot it I created a copy of the workbook and deleted all the code from the user form but still when those checkboxes are clicked the error occurs. If I delete the offending check box and put a new one in it's place it's OK.

Any idea whats happening here? I could just delete all the offending check boxes and put replacements in there but I'm worried the problem might surface again.

**Riggers** · 09-20-2011, 03:58 AM

Solved it. Checked boxes were linked to named cell and the sheet / cell was protected. Removing protection from those cells solved the problem. Not a very useful error message form Mr. Excel lol.

**royUK** · 09-20-2011, 07:43 AM

Try Protection with UserInterface. Is this actually a UserForm or a worksheet?

**Riggers** · 09-20-2011, 12:43 PM

Originally Posted by royUK

Tru Protection with UserInterface. Is this actually a UserForm or a worksheet?

I'm a novice so don't understand what you mean by Tru Protection with UserInterface.

In Excel Visual Basic Editor I've created a user form with checkboxes linked to a worksheet via the ControlSource property of the checkbox. I display the userform using a macro i.e. userform.show. If you try and click the check boxes when the worksheet is protected you get an exception error.

It took me a while to work out what the problem was due to the inadequacy of the error message description.

**royUK** · 09-20-2011, 12:45 PM

Do you need to use ControlSource? If you do that means changes in the UserForm will change the sheet & vice versa.

Protecting with UserInterface allows macros to work on protected sheets, but iI don't think it would help in this case

**Riggers** · 09-20-2011, 05:03 PM

Originally Posted by royUK

Do you need to use ControlSource? If you do that means changes in the UserForm will change the sheet & vice versa.

Protecting with UserInterface allows macros to work on protected sheets, but iI don't think it would help in this case

The user form allows the user to change configuration settings for the functionality in the workbook. I want these to persist across sessions of the workbook so I keep them in a hidden worksheet, hence the link to the cell using control source. I've done some googling of UserInterfaceOnly=True and it will be really useful, and indeed it does work with this user form.