Macros in protected sheet hiding/unhiding rows & cols

have the macro unprotect to make the changes, and then re-protect

Please Login or Register  to view this content.

.unprotect to unprotect it.

Sorry have not looked at your code for other suggestions, but thought you might like this input to start.

So my only concern about that is that if it's password protected, and it crashes in the middle of the macro, it's both left unprotected AND the password is plain-text visible in the macro, right? But if that's the only way to do it... this isn't financial information or anything, but it is sensitive data.

K

I might suggest reading up on error trapping. With an "onerror goto whatevername" statement, your code will go to that marker (whatevername elsewhere in the code. Often you put all the code that normally executes, and then type "exit sub" which stops the sub at that point. Then between "exit sub" and "end sub" you put whatevername: (I usuaully use the word handler for whatevername), followed by the code that would run if your error stopped normal code function. There I would re-enable events, screenupdating, and stuff like protecting sheet.

Sorry I hope that makes some sense? If you have questions don't hesitate

Example:

Please Login or Register  to view this content.