Hi, i have the below code
Its very simple, if the environ("username") = A1, then unprotect. If not protect. However, how do i make a list of environ("username")? Lets say all the username in Column A. If match is not error, then unprotect, if is error protect. How do i amend my code?
Please Login or Register to view this content.
how many users are you talking about?
you could just hard code it into the code itself
Please Login or Register to view this content.
Last edited by humdingaling; 04-06-2018 at 03:55 AM. Reason: le LCASE
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
One way
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Nice MethodOriginally Posted by kev_
@
- thank you for the rep
- I am lazy and prefer to use whole columns to avoid having to determine/specify a range
- my PC is lazy and prefers not to loop unless no alternative
Last edited by kev_; 04-06-2018 at 04:12 AM.
Nice post !!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks