+ Reply to Thread
Results 1 to 3 of 3

Locking and Unlocking Cells

  1. #1
    Forum Contributor vikas.bhandari's Avatar
    Join Date
    04-07-2006
    Location
    Delhi, India
    MS-Off Ver
    Office 2007 and 2010
    Posts
    303

    Locking and Unlocking Cells

    Hi All,

    I am not too sure if this requirement can be achieved with or without automation, so I thought to put this query under Excel Programming. I am designing an Excel Interface (not a form, just a layout in Excel Worksheet). In this layout, user will need to enter some information. Now I want to set up my worksheet in such a way, that the user should be able to select only cells which are required to provide the inputs. User should not be able to select any cells other than the input cells even. Is this possible? I know we can lock the cells but it doesn't stop user to select any other cells. Can someone help please?

    Thanks,
    Vikas
    Last edited by vikas.bhandari; 03-22-2010 at 10:28 AM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Locking and Unlocking Cells

    Hi,

    You need to ensure only the cells that you want the user to enter information into are unlocked (Format Cells...Protection) and then protect the worksheet. The worksheet protection dialogue gives you options as to whether a user is able to select locked cells or not.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Forum Contributor vikas.bhandari's Avatar
    Join Date
    04-07-2006
    Location
    Delhi, India
    MS-Off Ver
    Office 2007 and 2010
    Posts
    303

    Re: Locking and Unlocking Cells

    Dammn, thanks for that. I will brush up my skills before posting it.

    Vikas

+ 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