How to prevent from saving if some cells + textbox + combobox are blank ?

[francois.lemarie]

Hello
I am preparing a template with different sheets that users will have to fill in. I use cells and 2 activeX controls (textboxes and comboboxes):

I would like the users cannot be able to save the template if the following elements are blank:
-specific cells (eg. A1 in sheet1, A2 in sheet2)
-textboxes (eg Textbox1 in sheet1, Textbox2 in sheet2)
-comboboxes (eg. Combobox1 in sheet 1, Combobox2 in sheet2)

However, these specific cells, textbox and comboboxes blank must appear in blank when they will open it. So it implies to be able to save a file with it blank ONLY IF YOU KNOW THE PASSWORD (As the creator of the template, I would be the only person to know it). If you don't know the password you have to complete cells, textboxes and comboboxes to be able to save.


I thought about a message before saving for example : "Some elements are blank, please check it all, or enter the password to save with blanks" and a little space to put the password. If the password is not the good one another message would appear : "Please put correct password or fill the blanks". I am a newbie so if you have another idea, please be free to purpose !

Would anybody be kind to tell me how to do it ? ?
Even partial answers would be appreciated.

Regards,

Francois

 

[Gerald Higgins]

Looks like yet another duplicate thread.
http://www.mrexcel.com/forum/showthread.php?t=459697

I'm not a moderator, but if no-one answers your first post, I don't think you should be starting new threads. Feel free to bump the original.

 

[francois.lemarie]

Hi Gerald, I have duplicated threads because nobody answered and the thing was quite urgent so I wanted the thread to be more visible.

I would like to borrow the previous post when I have to create a copy of a previous thread but have absolutely no idea about how to do it. For these reason some threads are duplicated. Do you know a way to borrow its own threads?

 

[Gerald Higgins]

What do you mean by "borrow the previous post" ?
Why would you want to "create a copy of a previous thread" ?
What do you mean by "borrow its own threads" ?

The preference on this board is, if no one answers your first post (after a suitable length of time), then you can bump it, to send it back onto the first page (though maybe only for a few minutes if the board is busy!).
If you want to bump it, just reply to the original post with the word "bump".

For the record, I personally don't know how to solve your original question, but I am quite confident that it can be done. Try searching this board for things like "On Save Event".