How to protect collumn formula
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to protect collumn formula

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

    Default

     
    Dear,

    I setup a formula for collumn, and I don't want anyone to change it.

    But I don't know how to setup it.

    Lyvia

  2. #2
    Guest

    Default

      
    On 2002-03-10 19:51, LyviaChung wrote:
    Dear,

    I setup a formula for collumn, and I don't want anyone to change it.

    But I don't know how to setup it.

    Lyvia

    do you just want to protect that column? if so select all columns except the one you don't want to be changed,(hold down the ctrl key to select multiple columns, or if you're selecting all columns to the right of the one you want to protect hold down ctrl+shift and press the right arrow key)and go to format menu>cells>protection tab and uncheck the 'locked' checkbox. then go to tools menu>protection and protect the sheet as instructed. then any cell except those in your protected column can be edited. is that what you wanted?

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
  •  

 

 
DMCA.com