+ Reply to Thread
Results 1 to 2 of 2

Locking cells

  1. #1
    Dave Elenor
    Guest

    Locking cells

    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



  2. #2
    Gord Dibben
    Guest

    Re: Locking cells

    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
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1