+ Reply to Thread
Results 1 to 3 of 3

Lock specific cells

Hybrid View

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    18

    Lock specific cells

    I created a program that requires an input to the user in the specific cells and if he clicked the button (VB codes), it will print the output in the other cells.
    I successfully locked the non-input cells (so that the users will only put numbers in the input cells) but when I clicked the button, there's an error. It looks like it qualifies it as an edit in the locked cells.

    If you know how to solve this or know other methods to lock the non-input cells, it would be a help. I only want the users to avoid encoding characters in the non-input cells. Thanks.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Lock specific cells

    If you have allowed the Input cells without Lock InputCells>>FormatCells>>Protection>>UncheckTickMark then you wont get that error.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-08-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Lock specific cells

    Select cell>right click> Format cell> Protection> click locked

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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