Force cells to be filled before file can be saved

[dw_22801]

Good Afternoon,

Is there a way to force a user to fill out certain cells, they use data validation, or they cannot save the file? I guess pop up a msg saying you must fill out blah blah before you can save.

Thanks!

[Winon]

Hello dw_22801,

Yes. It can be done, but then we need to know which Cells require mandatory data.

Please attach a sample workbook (not a picture or pasted copy).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[dw_22801]

Thanks! The Lease Deal Sheet tab is the one that requires info. Just the brown highlighted fields should be required. You will see there is some code that allows populating in the drop downs, so I would like that to stay. Also, can all fields be cleared out once it closes, too? So each time its opened, the user has to enter the info from the beginning? So in summary, can we require each brown field to be filled out, if not, then a msg box tells them to fill out all required fields, and they cannot save the file. Then once they have filled out, when they close the sheet, all of the fields are cleared?


Thanks!

[kvsrinivasamurthy]

Code for workbook Event

Please Login or Register  to view this content.

[dw_22801]

That's great! Can we have the following events? Can we have it where once an attempt to close happens, and Yes to save is hit, the msg box comes up as it does, but also it doesn't actually close at that point. So it only closes when No to save is chosen?

[kvsrinivasamurthy]

Revised code

Please Login or Register  to view this content.

[dw_22801]

Awesome! Not sure if I'm missing something, but should it be clearing out all the fields when it closes? Basically I am trying to force the user to enter all of the information from blank fields each time they open it in order to reduce instances of wrong info. I don't want them to be able to leave info from a previous sheet. They basically create one of these for each new contract we do and send a copy out. Thanks for your help!

[Winon]

Hello dw_22801,

I am now totally confused, as you state in Post#3,

Also, can all fields be cleared out once it closes, too? So each time its opened, the user has to enter the info from the beginning? So in summary, can we require each brown field to be filled out, if not, then a msg box tells them to fill out all required fields, and they cannot save the file. Then once they have filled out, when they close the sheet, all of the fields are cleared?

And now you ask,

Awesome! Not sure if I'm missing something, but should it be clearing out all the fields when it closes?

[dw_22801]

When I close out the sheet, the fields are not clearing, but that is what I was hoping to do. It opens up and the same info is in each field.

[dw_22801]

I guess I phrased the second question incorrectly. I am wanting it to clear out the fields, but the last sheet I tried was not doing that.

[Winon]

Hello dw_22801,

Expanding on what kvsrinivasamurthy had given you, please replace this Code below;

Please Login or Register  to view this content.

With this Code;

Please Login or Register  to view this content.

And tell me it is working now.

Regards.

[dw_22801]

Close. It looks like when it is saved successfully and closed, the fields aren't cleared. Can that happen too? So the sheet never opens with info in the fields?

[Winon]

Hello dw_22801,

So the sheet never opens with info in the fields?

To accomplish that, we simply add the Code below;

Please Login or Register  to view this content.

Play around with the attached sample Workbook now, and enjoy!

Regards.