Consulting

Results 1 to 2 of 2

Thread: make a column read only using vba

  1. 10-12-2010, 03:43 AM #1
    Anusree
    Anusree is offline
    VBAX Newbie
    Joined
    Oct 2010
    Posts
    4
    Location

    make a column read only using vba

    Hi,
    I want to make column B of sheet1 as readonly by writting vba code. Is this possible?

    Regards,
    Anu
    Reply With Quote Reply With Quote
  2. 10-12-2010, 04:40 AM #2
    Bob Phillips
    Bob Phillips is online now
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    [vba]

    Cells.Locked = False
    Columns("B:B").Locked = True
    ActiveSheet.Protect
    [/vba]
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules