s_macloskey
New Member
- Joined
- Jul 1, 2020
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi all,
Please see the screenshot I've attached.
I have made a holiday request sheet for staff.
The sheet is protected by a password (excluding the blue cells to allow for requests to be entered)
Is there a way I can make a VBA utton at the end of each line so that the staff can LOCK each line seperately (to keep thier request safe) and to then be unlocked by the main sheet password by a manager?
Any suggestions at all are welcome,
Thanks!
S Macloskey
Please see the screenshot I've attached.
I have made a holiday request sheet for staff.
The sheet is protected by a password (excluding the blue cells to allow for requests to be entered)
Is there a way I can make a VBA utton at the end of each line so that the staff can LOCK each line seperately (to keep thier request safe) and to then be unlocked by the main sheet password by a manager?
Any suggestions at all are welcome,
Thanks!
S Macloskey