Results 1 to 6 of 6

Thread: Locking cell...

  1. Jun 8th, 2006, 03:08 AM #1
    daimous
    daimous is offline

    Thread Starter
    Fanatic Member daimous's Avatar
    Join Date
    Aug 2005
    Posts
    657

    Locking cell...

    hi guys!!! i have a question, how can i locked the sheet with only 'select unlocked cells' enabled. at present i only have this code which locked and unlocked sheet but with 'select locked cells' and 'select unlocked cells' enabled..but i only want 'select unlocked cells' enabled. thanks in advance!!!
    VB Code:
    1. Sheet1.Unprotect ("bcmd")

    2. Sheet1.Protect ("bcmd")
    Reply With Quote Reply With Quote
  2. Jun 8th, 2006, 08:10 AM #2
    DKenny
    DKenny is offline
    Frenzied Member DKenny's Avatar
    Join Date
    Sep 2005
    Location
    on the good ship oblivion..
    Posts
    1,171

    Re: Locking cell...

    VB Code:
    1. Sheet1.Protect ("bcmd")

    2.     Sheet1.EnableSelection = xlUnlockedCells
    Declan

    Don't forget to mark your Thread as resolved.
    Take a moment to rate posts that you think are helpful
    Reply With Quote Reply With Quote
  3. Jun 8th, 2006, 06:47 PM #3
    daimous
    daimous is offline

    Thread Starter
    Fanatic Member daimous's Avatar
    Join Date
    Aug 2005
    Posts
    657

    Re: Locking cell...

    Thanks a bunch!!! DKenny!
    Reply With Quote Reply With Quote
  4. Jun 8th, 2006, 07:07 PM #4
    daimous
    daimous is offline

    Thread Starter
    Fanatic Member daimous's Avatar
    Join Date
    Aug 2005
    Posts
    657

    Re: Locking cell...

    wait..i still have a problem...i've already try your code and it works but when I save my excel document and close it and open it again the cells that are locked is can be selected again..why is that so? I dont want locked cells to be selected. thanks in advance!
    Reply With Quote Reply With Quote
  6. Jun 8th, 2006, 07:10 PM #5
    malik641
    malik641 is offline
    Addicted Member malik641's Avatar
    Join Date
    Sep 2005
    Location
    South Florida :-)
    Posts
    221

    Re: Locking cell...

    Just put DKenny's code in the "ThisWorkbook" module in an open event:

    VB Code:
    1. Private Sub Workbook_Open()




    If you find any of my posts of good help, please rate it
    Reply With Quote Reply With Quote
  7. Jun 8th, 2006, 07:31 PM #6
    daimous
    daimous is offline

    Thread Starter
    Fanatic Member daimous's Avatar
    Join Date
    Aug 2005
    Posts
    657

    Re: Locking cell...

    is there any other solution aside from putting it from
    VB Code:
    1. Private Sub Workbook_Open()
    ?
    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


Click Here to Expand Forum to Full Width