Results 1 to 4 of 4

Entering in data in specific cells using range protect or locking the cells

Threaded View

howard101 Entering in data in specific... 04-05-2008, 06:29 AM
royUK Protecting Cells will not... 04-05-2008, 07:17 AM
royUK I think this is what you want... 04-05-2008, 08:18 AM
royUK Example for above 04-05-2008, 11:05 AM
  1. #1
    Registered User
    Join Date
    11-11-2007
    Posts
    25

    Entering in data in specific cells using range protect or locking the cells

    I would like VBA Code that will that will protect the following cells i.e force me to enter cells in the following ranges

    A2, A5, A7, C2, D2. When I enter twice after enter data in D2, then macro must end

    Your assistance will be most appreciated

    Howard
    http://www.mrexcel.com/forum/showthr...ghlight=howard
    Attached Files Attached Files

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