+ Reply to Thread
Results 1 to 2 of 2

Mandatory range of cells

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Question Mandatory range of cells


    Is there a way to make certain cells mandatory to be completed in Excel, or else they cannot save or complete a template? It's not just one cell, but a range. Thanks in advance for your help.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit

    Re: Mandatory range of cells

    It requires VBA to check the cells upon a Save event. If you attach a sample file and indicate which cells are mandatory we can provide the specific code.
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. mandatory cells
    By xam99 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-14-2020, 02:58 PM
  2. Make cell entry in a range mandatory
    By h4a4r6r6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-20-2019, 01:03 PM
  3. Mandatory Cells
    By Rich789 in forum Excel General
    Replies: 1
    Last Post: 08-24-2017, 08:33 AM
  4. How can I make multiple cells mandatory if new rows are used with some cells left blank?
    By markbarnett in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-11-2015, 07:06 AM
  5. Make several cells mandatory if a cell in a range is filled out
    By steeveho in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-18-2013, 06:49 AM
  6. Mandatory field required message when user skips mandatory fields
    By Bharathi27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2013, 05:12 AM
  7. Mandatory Cells
    By Mel1221 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-05-2006, 05:10 PM

Tags for this Thread


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