I have a protected workbook with several protected sheets. I have written VB code tied to various buttons and drop down which mainly hide and show various rows in the sheets. Everytime a function or sub is run they unprotect the workbook and sheets, run the code, then protect everything once completed, however when I click on the checkboxes and drop downs that I am using I get an error stating the the cell or sheet is protected and they need t obe unprotected first, however if I click OK all my code runs and everything is fine.

Is there a way to not have the protection error dialog pop-up everytime I click a control?

The error pops up before it even gets into the VB code, so I am sure there is nothing wrong with the code. It just annoying to click on the dialog everytime.