Hi Everyone,
When I do a budget template, I would like to lock some cells, but when I used protect sheet and set the password, it would lock all the cells. How can I just lock some cells?
Thank you so much,
Hi Everyone,
When I do a budget template, I would like to lock some cells, but when I used protect sheet and set the password, it would lock all the cells. How can I just lock some cells?
Thank you so much,
Select the cells that you DO NOT want to lock, then right-click and choose "Format Cells" OR simply press Ctrl+1. Once the menu pops up, navigate to the tab labeled "Protection", uncheck the "Locked" box, and hit the "OK" button. When you protect the sheet, these cells will still be available for editing.
As explained, you need to 1st UNprotect what you want, then protect the sheet
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks