+ Reply to Thread
Results 1 to 8 of 8

can v lock column

  1. #1
    Forum Contributor
    Join Date
    06-02-2005
    Location
    India
    MS-Off Ver
    2007
    Posts
    138

    Question can v lock column

    how to lock any specified column or row in excel or through vba??

    I don't require any splitting / freezing panes.

    If locked, user should not able to edit/delete any of the cells of locked column or row.

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    1. Select al cells, click Format > Cells > Protection tab and uncheck the Locked tab.
    2. Slecte the cells / columns / rows which you want to lock. Go to Format > Cells > Protection tab and check the Locked tab.
    3. Now go to Tools > Protection > Protect sheet. You may supply a password if needed.

    Mangesh

  3. #3
    Forum Contributor
    Join Date
    06-02-2005
    Location
    India
    MS-Off Ver
    2007
    Posts
    138

    Thumbs up

    mangesh, thanku once again

  4. #4
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    Thanks for the feedback.

    Mangesh

  5. #5
    Harald Staff
    Guest

    Re: can v lock column

    Please Login or Register  to view this content.
    HTH. Best wishes Harald

    "ilyaskazi" <[email protected]> skrev i
    melding news:[email protected]...
    >
    > how to lock any specified column or row in excel or through vba??
    >
    > I don't require any splitting / freezing panes.
    >
    > If locked, user should not able to edit/delete any of the cells of
    > locked column or row.
    >
    >
    > --
    > ilyaskazi
    > ------------------------------------------------------------------------
    > ilyaskazi's Profile:

    http://www.excelforum.com/member.php...o&userid=23969
    > View this thread: http://www.excelforum.com/showthread...hreadid=376228
    >
    Last edited by Cutter; 08-28-2012 at 12:41 PM. Reason: Added code tags

  6. #6
    Mike Fogleman
    Guest

    Re: can v lock column

    Add rows to Haralds code:

    Please Login or Register  to view this content.
    MIke F

    "ilyaskazi" <[email protected]> wrote
    in message news:[email protected]...
    >
    > how to lock any specified column or row in excel or through vba??
    >
    > I don't require any splitting / freezing panes.
    >
    > If locked, user should not able to edit/delete any of the cells of
    > locked column or row.
    >
    >
    > --
    > ilyaskazi
    > ------------------------------------------------------------------------
    > ilyaskazi's Profile:
    > http://www.excelforum.com/member.php...o&userid=23969
    > View this thread: http://www.excelforum.com/showthread...hreadid=376228
    >
    Last edited by Cutter; 08-28-2012 at 12:40 PM. Reason: Added code tags

  7. #7
    Registered User
    Join Date
    08-27-2012
    Location
    Coimbatore,India
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: can v lock column

    Hi all, I'm facing a similar problem...how to disable editing or protect only a specified column..
    i'm getting error..
    don know what to do..
    help me pls

  8. #8
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: can v lock column

    Hello SathishKumar, and welcome to the forum.

    Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

+ 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