Run VBA on Protected worksheet

Hi

I am having a similar problem to Bob@sun.

I am new at VBA's and can't figure out how to incorporate the 'Userinterfaceonly" part into my code

Basically:
- I want If column 3 (i.e. c) is zero, then I want to hide rows 44-57 , 66-69, and 91 - 104
- This works until i protect the worksheet
- I have tried to incorporate 'ActiveSheet.Unprotect Passsword: ='Secret' and ActiveSheet.Unprotect Password:="Secret" but can't subsequently unprotect my worksheet

How can I run VBA in a protected worksheet without it subsequently being all protected?

this is my code:

Please Login or Register  to view this content.

Any help with telling me how my code should be is much appreciated!!

thanks

The UserInterfaceOnly flag has to be turned on each time the sheet is opened and/or unlocked and relocked. That particular parameter does not survive the closing of the workbook... dumb, but that's how it is.

So, you're code will work as is, it appears you are using the more common technique of simply unprotecting, doing your stuff, and then protecting again. That works, and it introduces no headaches like UserInterfaceOnly can do if it gets turned off somehow and all your macros stop working. Is it really worth the effort?


BTW, don't forget CODE tags, I've added them to the post above, you'll need to do that from now on, OK?

ah - sorry, will do CODE tags from now on.

Also my code up there says 'unprotect' on the second last line, it actually says 'protect' (otherwise i get the code error '400')

So everything stays protected after run it, how do I unprotect it?

Originally Posted by Dukes

....how do I unprotect it?

By taking that line completely out.