View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Can I Protect Just A Few Cells On A Worksheet?

Sleet the whole worksheet, goto FormatCellsProtection and uncheck Lock.

Select the cells to protect, goto FormatCellsProtection and check Lock.

Now protect the sheet, ToolsProtectionProtect Sheet...

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Joe Miller" wrote
in message ...

Can I protect just a few cells on a worksheet - and if so, how?

Thanks,
Joe Miller


--
Joe Miller
------------------------------------------------------------------------
Joe Miller's Profile:

http://www.excelforum.com/member.php...o&userid=29900
View this thread: http://www.excelforum.com/showthread...hreadid=571330