| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I Protect Just A Few Cells On A Worksheet?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I Protect Just A Few Cells On A Worksheet?
Sleet? I mean Select.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Bob Phillips" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I Protect Just A Few Cells On A Worksheet?
Thanks Bob -- 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Only an Object on a Worksheet | Excel Discussion (Misc queries) | |||
| How to name cells using same name yet specific to worksheet in Exc | Excel Worksheet Functions | |||
| ... After I protected my worksheet, some cells can be changed... | Setting up and Configuration of Excel | |||
| how do I protect a worksheet and still use a checkbox control | Excel Worksheet Functions | |||
| Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
