If I protect a sheet through Tools/Protection, a button that runs a macro to hide rows cannot be executed without having to enter the password to unprotect it (which defeats the purpose of protecting the worksheet).
I know there is a way to protect through coding. Please give me a hand to solve this.
Thanks
I know there is a way to protect through coding. Please give me a hand to solve this.
Thanks