hI,
WILL IT BE POSSIBEL TO lock columns / cells for any user to avoid editiing ?
Only the creatorof teh file should be able to edit ?
Thanks
mani
hI,
WILL IT BE POSSIBEL TO lock columns / cells for any user to avoid editiing ?
Only the creatorof teh file should be able to edit ?
Thanks
mani
hi Shadmani.
1. select the entire worksheet first by pressing CTRL + A or click on the box on the left of Column A & on top on row 1. press CTRL + 1 to go to Format Cells. go to the tab "Protection". Uncheck the "Locked". press OK.*
2. now select only those you want to lock (i.e. those columns or cells). again, CTRL + 1 & go to the tab "Protection". Check back the "Locked".*
3. Now, right-click the Sheet & Protect Sheet. only those you did in Step 2 will be locked. if you want to edit, you have to unprotect the sheet
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
You will get more links which will describe it in detail by just doing a google search Protect Sheet in 2003
I seen this one is detailed one for you
http://www.techonthenet.com/excel/cells/protect.php
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks