Morning guys,
Having some problems with protecting sheets. I've tried the wizard with no luck, so can anyone give me a step by step way of doing the following please:
I want to lock the entire sheet with the exception of columns F,G and H, that I want staff to be able to enter values in.
Many thanks
Last edited by Cmorgan; 11-14-2011 at 02:29 AM.
Select column F, G & H
In format cell in tab protection uncheck the Locked
In review tab click on protect sheet
check selected unlocked cells and uncheck all other. give password if you need
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
So simple when you know how. Many thanks
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks