+ Reply to Thread
Results 1 to 2 of 2

Allow entry into selected cells

Hybrid View

  1. #1
    Registered User
    Join Date
    09-29-2006
    Location
    NC -USA
    Posts
    6

    Allow entry into selected cells

    I want to protect most of a spreadsheet, but not all of it. How do I allow a user to enter data into just certain cells? I have looked at Tools > Proctection > and the options there. I can see where is allows me to protect the entire sheet or a range but not selected cells or allow just entry into some.
    I want to allow a user to enter data into 5 entry cells. ( b3, b5, c7, c9, and c11)

    Thanks
    Cas

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Try selecting the cells then right click > format cells > protection Tab then unselected locked cells.

    Then when you protect the sheet it should work

    VBA Noob

+ Reply to Thread

LinkBacks (?)

  1. Page
    Refback This thread
    10-04-2013, 06:21 AM

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