Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: protection

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    sandy
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can i just protect certain columns say b , f, j, and not the whole page or can i protect cells with formulas in them
    thank you

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Baz, similar to:
    http://www.mrexcel.com/board/viewtop...2080&forum=2&7

    Just select your sheet, format the cells as unlocked. Select your columns, format as locked, then protect the sheet. Hope that helps.

    Cheers, Nate

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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