Can I lock different cells
say A2 A4 A6 after that open and close workbook anytime and never have to
unlock them, and still be able to use all other cells in the workbook
Can I lock different cells
say A2 A4 A6 after that open and close workbook anytime and never have to
unlock them, and still be able to use all other cells in the workbook
Dave
By default all cells are locked when the sheet is protected.
Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.
Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.
Now Tools>Protection>Protect Sheet. Save the workbook.
Gord Dibben Excel MVP
On Fri, 18 Feb 2005 16:40:12 GMT, "Dave Elenor" <[email protected]>
wrote:
>Can I lock different cells
>
>say A2 A4 A6 after that open and close workbook anytime and never have to
>unlock them, and still be able to use all other cells in the workbook
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks