I need to protect the whole sheet except for a small area where data can be entered and if possible make it so that the work sheet can be sorted. I have attached an example sheet.
Thanks ken
I need to protect the whole sheet except for a small area where data can be entered and if possible make it so that the work sheet can be sorted. I have attached an example sheet.
Thanks ken
Last edited by g48dd; 06-07-2009 at 07:41 PM.
Do
1. Ctrl+A
2.Ctrl+1 > Protection > unmark "Locked"
3.Select grey zone and press ctrl+1 > protection > mark "LOCKED"
4. Tools > Protection > ProtectSheet
TYPE PASS AND PRESS OK.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Great thank you, you know what bad I am just a normal guy that knows how to do a few things with excel and I can build better spread sheets than what this company is using, and I know so littel about basic stuff. Maybe I should buy a book read it cover to cover and apply for job that here where the guy who's spread sheet I am correcting makes 1500 dollars more a month than me lol
Thanks again
Ken
I never take craedit for work that is not mine!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks