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:
Any help with telling me how my code should be is much appreciated!!
thanks
Bookmarks