Run-time error when hiding columns in protected workbook

Hello,

I have a listbox whose selections hide or unhide particular columns. I receive a run-time error 1004 only when I attempt to use this after just having activated the protected workbook. If I unprotect the workbook and reprotect it, the listbox functions properly from then on. I only have trouble if I haven't yet unprotected it.

I have unlocked all of the cells in the columns I am hiding as I thought this might be the issue. Can anyone offer me some suggestions? Here is the code I'm using with the error messages listed below:

Please Login or Register  to view this content.

“400” Error message

“Run-time error ‘1004’:
Application-defined or object-defined error”

Thanks ahead of time!

Joe

Joe

Perhaps, have code to unprotect, followed by the hidey columns and then have code to reprotect.

Hi and welcome to the forum.

Pls take few minutes to read forum rules, because:

Your Post does not comply with number 3 rule of our forum. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button

Joe

Have you tried unlocking the listbox before protecting?

You might have to unprotect the cells associated with it to.

I think seeing a workbook would be helpful.

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Which line of code is the error on?

Joe

I really think it would help if you uploaded a workbook.

Otherwise all we can do is make guesses and suggestions.