Results 1 to 6 of 6

Conditional Lock Cell

Threaded View

Giah98 Conditional Lock Cell 10-20-2008, 04:46 PM
Kieran Giah98, you appear to ahve... 10-21-2008, 12:45 AM
royUK You cannot lock a cell with a... 10-21-2008, 04:14 AM
Giah98 The spreadsheet is simple,... 10-23-2008, 03:38 PM
royUK What's wrong with the... 10-24-2008, 02:41 AM
Giah98 The conditional formatting... 10-24-2008, 09:42 AM
  1. #1
    Registered User
    Join Date
    10-16-2008
    Location
    Chicago
    Posts
    3

    Conditional Lock Cell

    Hello,

    I'm new to programming and I have been looking on how to create a simple worksheet for a hotel manager where I can lock two different cells when another cell has entry. (It's pretty much showing that when a two bedroom is reserved, the one bedroom and hotel room beside it cannot be reserved.) I included an attachment. For example, is if B36:F36 (or merged together with entry) has an entry then B15:F15 and B31:F31 become locked and cannot enter in these cells.

    Is it possible to add a box that is required to fill out when entering in these rows B35:AE38 so when a those cells are entered (two bedroom is reserved) a pop up window will show up when you select the reflecting hotel rm or one bedroom?

    Would there be an easier way to do the conditional lock other than using Macro?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. lock preceeding cell if previous left blank
    By kaspr79 in forum Excel General
    Replies: 1
    Last Post: 06-26-2008, 01:42 PM
  2. Conditional cell lock
    By coolanks in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-30-2008, 09:57 AM
  3. Conditional Format- Blank cell with formula problem
    By Trappy in forum Excel General
    Replies: 4
    Last Post: 08-20-2007, 09:51 AM
  4. Conditional Formatting based on 3 different cell values (criteria)
    By xlguy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-05-2007, 05:36 AM
  5. Conditional Format a cell based on a range of numbers
    By fablhof in forum Excel General
    Replies: 2
    Last Post: 04-27-2007, 11:39 PM

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