Hello all!
I need help with a macro to password protect and unprotect several sheets at once - and prompt the user when an incorrect password is given. Also, when each sheet is protected I would like user only to have access to 1. group/ungroup, 2. edit column widths, 3. access unlocked cell, 4. select but not edit locked cells.
I haven't been able to cobble anything together that give me all requirements in 1 macro. I wish this stuff came easy to me
Thanks for your help.
I need help with a macro to password protect and unprotect several sheets at once - and prompt the user when an incorrect password is given. Also, when each sheet is protected I would like user only to have access to 1. group/ungroup, 2. edit column widths, 3. access unlocked cell, 4. select but not edit locked cells.
I haven't been able to cobble anything together that give me all requirements in 1 macro. I wish this stuff came easy to me

Thanks for your help.