Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row protection
I have a large spreadsheet that I need to protect some rows. These rows are not in sequence or determined interval. These rows contain formulas which I would like them to be password protected. -- ab3d4u |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row protection
I'm guessing that your core problem lies in selecting all the formula cells
You can press F5SpecialCheck FormulasOK to select all cells with formulas in that sheet in one go Usual sequence to protect: "Unlock" entire sheet (via FormatCellsProtection tab), then "Lock" all formula cells in the sheet (after selecting as above, via FormatCellsProtection tab) Apply ToolsProtectionProtect Sheet (password, etc) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "ab3d4u" wrote in message ... I have a large spreadsheet that I need to protect some rows. These rows are not in sequence or determined interval. These rows contain formulas which I would like them to be password protected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Protection | Excel Worksheet Functions | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Protection... | Excel Discussion (Misc queries) |