Results 1 to 8 of 8

How to link multiple Dependant dropdown and "lock the cells"

Threaded View

  1. 09-19-2018, 02:42 AM #1
    ec4excel
    ec4excel is offline
    Registered User
    Join Date
    08-09-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007/2010/365
    Posts
    82

    How to link multiple Dependant dropdown and "lock the cells"

    I need help to create a form for users and each users has certian rights to certain cells.

    In the attached workbook, Authorised users will be selected in F13. The Rights needed will be R13 (Priority), and Row 31 to 33 for supplies.

    I am no good in using VBA and can this be done in using Dependant Dropdown list and fomulars?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to use Nested "IF" and "AND" commands to generate text from data on multiple cells
    By ogbuehi1 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-24-2017, 11:53 AM
  2. Using "index", "match", "min", "abs", to find the closest value in multiple criteria
    By escariojm in forum Excel General
    Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  3. Re-Do -- Changing colour in cells "Date Dependant"
    By DavoP in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2015, 06:03 PM
  4. [SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2013, 05:36 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. [SOLVED] Changing colour in cells "Date Dependant"
    By DavoP in forum Excel General
    Replies: 3
    Last Post: 05-06-2013, 10:31 PM
  7. Change "Parent" cell based on results of multiple "Children" cells
    By ccowman in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-14-2012, 02:33 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1