Ato move row and checkboxes visible by user
I am creating a workbook where employees will update the status of tasks they
have been assigned. I need to be able to make it so that when they open the
workbook, they have to enter a password that allows them to only edit the
"status" column. When I enter my password upon opening the workbook, I can
sleect a checkbox in column G that will delete the checked row from the
"Active" tab and paste it into the "Completed" tab (into the next available
row). Lastly, is there a way to make the checkbox hidden when the employee is
logged in and visible when I log in?
Thanks,
Kevin
|