Hi all,
I'm having to send one worksheet to three users, but don't want them 'accidentally' messing up everyone else's data. I have each user's sheets color coded, and want a macro to lock each colored section with the same password, so that there are 3 passwords (one for each user). Also, leaving it to where we can select locked cells would be great.
I had pieced one together, and it looked like this
However, it wouldn't skip to the next wSheet, nor did it protect any sheets.
My tab colors are 17, 43, and 33 if that will help with the code-writing.
Thanks!
Bookmarks