+ Reply to Thread
Results 1 to 2 of 2

How to restrict cell from saving without selecting any value from its drop-down.

  1. #1
    Registered User
    Join Date
    04-24-2019
    Location
    India
    MS-Off Ver
    16
    Posts
    1

    How to restrict cell from saving without selecting any value from its drop-down.

    I need my customer to select drop-down for sure,without selecting it user should not be able to move to the next cell

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: How to restrict cell from saving without selecting any value from its drop-down.

    For some unknown reason firewall see SQL injection in my post, so I have to post this way.

    Capture.JPG
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 05-09-2017, 02:42 PM
  2. [SOLVED] My Code to restrict user from Saving in other than XLSM format does not work as intended.
    By kiranpat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2014, 02:02 PM
  3. Need to restrict Saving & Printing a spreadsheet
    By shaung411 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2014, 01:33 PM
  4. Open Drop down list by selecting cell
    By barqujo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2013, 08:00 PM
  5. Prompt for password after selecting from dropdown, also restrict data
    By balaji3081 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-11-2013, 04:41 PM
  6. Restrict entry in various cells based on drop down choice in another cell
    By Stretch617 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2013, 04:09 PM
  7. Selecting from drop down dependant on cell value
    By Andy_Musetti in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2011, 10:39 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1