| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Beginer's problemBeginner's problem
Thank you Gord, it works!
Cheers, Milan Karakas --- Gord Dibben wrote: Milan By default all cells are locked when the sheet is protected. Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked" and OK. Select the cells you wish to lock and FormatCellsProtection. Check "locked" and OK Now ToolsProtectionProtect Sheet. This is mandatory. You can set a password to unprotect the sheet. These can easily be broken in Excel but will keep your formulas from being accidentally overwritten. NOTE the options available in xl2002 and 2003 when you hit Protect Sheet Gord Dibben MS Excel MVP On Wed, 24 Jan 2007 02:09:44 +0100, Milan Karakas wrote: P.S. Still, I don't know how to protect, or lock formulas to prevent accidentally overwriting. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem using newly created user function in Excel 2003 | Excel Discussion (Misc queries) | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Hybrid Mode
