stevespaulding
New Member
- Joined
- Jan 29, 2008
- Messages
- 37
1. Have worksheet that I want to protect so that users can only access unlocked cells, but need to do sort in middle of macro run. Sort will not work if worksheet is protected. Can worksheet be unprotected (without password) to do sort and then protected again? If so, how?
2. How can I lock and/or hide my macro VBA code so that it cannot be seen or inadvertently altered by a user?
3. How can I prevent (or at least control) a user from copying or sending my Excel program (workbook with macro) to someone else without my authorization?
Many thanks!
2. How can I lock and/or hide my macro VBA code so that it cannot be seen or inadvertently altered by a user?
3. How can I prevent (or at least control) a user from copying or sending my Excel program (workbook with macro) to someone else without my authorization?
Many thanks!