I need to lock some cells so other users cannot modify them. However, they
still need to modify other areas of the spreadsheet? Can i do this? If,
Yes... HOW?
Thanks...
I need to lock some cells so other users cannot modify them. However, they
still need to modify other areas of the spreadsheet? Can i do this? If,
Yes... HOW?
Thanks...
Click the select all button above row one and to the left of the column
header A to select sheet
Menu Format>Cell>Protection, uncheck the Locked option, OK
Select the range of cells to be locked
Menu Format>Cell>Protection, check the Locked option, OK
Menu Tools>Protection>Protect sheet.
--
HTH
Bob Phillips
"Banana" <Banana@discussions.microsoft.com> wrote in message
news:D768ECF6-C63D-4740-A9E1-6C1482D381B3@microsoft.com...
> I need to lock some cells so other users cannot modify them. However, they
> still need to modify other areas of the spreadsheet? Can i do this? If,
> Yes... HOW?
>
> Thanks...
Here you go, Banana:
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Banana" <Banana@discussions.microsoft.com> wrote in message
news:D768ECF6-C63D-4740-A9E1-6C1482D381B3@microsoft.com...
> I need to lock some cells so other users cannot modify them. However, they
> still need to modify other areas of the spreadsheet? Can i do this? If,
> Yes... HOW?
>
> Thanks...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks