GTretick
Member
I work in an Excel file that has multiple worksheets and can have additional ones added daily.
We lock off a worksheet when it is completed but sometimes need to go back to make amendments.
It can be very time consuming to go back and unlock 30 sheets make the change and then lock them back up again. The file/info menu option doesn't help that area too much.
What I'd like is to have a worksheet called say "Lock Control" that lists out all the worksheets currently in the workbook (as worksheets are added the list will expand) then the user can mark an "x" next to the worksheet to determine what state they want it in (locked or unlocked - or stay the same if no "x" is entered) then go through the workbook and change the lock status as required when we push a "Go" button. A password can be entered in an input area (or popup box if you want to be fancy) to use in order to set the status.
I've tried looking at this online and the answers don't seem to get me there. Hopefully someone with better VBA than me can recommend something.
I've attached a basic workbook to illustrate what a basic workbook might look like.
Thanks.
We lock off a worksheet when it is completed but sometimes need to go back to make amendments.
It can be very time consuming to go back and unlock 30 sheets make the change and then lock them back up again. The file/info menu option doesn't help that area too much.
What I'd like is to have a worksheet called say "Lock Control" that lists out all the worksheets currently in the workbook (as worksheets are added the list will expand) then the user can mark an "x" next to the worksheet to determine what state they want it in (locked or unlocked - or stay the same if no "x" is entered) then go through the workbook and change the lock status as required when we push a "Go" button. A password can be entered in an input area (or popup box if you want to be fancy) to use in order to set the status.
I've tried looking at this online and the answers don't seem to get me there. Hopefully someone with better VBA than me can recommend something.
I've attached a basic workbook to illustrate what a basic workbook might look like.
Thanks.