Can you make a field mandatory in excel

On Friday I did this, saved the file. So when I created a new document with the template, it prompted me for the required fields fine. Now today I come into work and was going to do some more testing and guess what??? It won't let me close the template without the required fields in those cells!! What did I do different? Hmmmmm John. You must log in or register to reply here.

Similar threads J. Question VBA - transfer data from one worksheet to another based on unique reference. Replies 1 Views Oct 29, DanteAmor. Question How can I return the first non-blank cell in a range of formulas? HawaiianShirts Aug 19, Excel Questions. Replies 8 Views Aug 20, Fluff. Replies 0 Views Apr 15, dunhamsasphalt. Rnkhch Jul 22, Excel Questions 2. Replies 12 Views Jul 27, Rnkhch. I have a command button setup to submit a form via email but want to make certain cells mandatory before the button will submit the email.

Hi, Craig, sorry this problem cannot be solved here, maybe other else can help you. I want to make rows C2 to C7 mandatory and C13 to C19 mandatory?

Any help? Is there any way that I can Required cell f4 and F5 have data before closing or saving? Just change B1 to F4 and F5 in the textbox to remind users. Hello, thank you for this formula, it works! However, now I have created a template in which several cells are mandatory to fill out. But after creating the template and entering the macro, I cannot close it, because I have to fill out the cells : So, I cannot send out a template It can then be saved and will restart when next opened.

Click the middle pause button then you can save. Chihiro said:. There's more elegant way to do it. But this will do what's needed. Cells 2, C If. Do you like it? So thanks to click on bottom right Like! Something like Code:. Slightly modified!! Hi Deepak, Nice. I like the use of LEN. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta.

Now live: A fully responsive profile. Linked 0. Related 3. Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled.