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

[francois.lemarie]

<TABLE class=tborder id=post2269902 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 0px solid" width=175></TD><TD class=alt1 id=td_post_2269902 style="BORDER-RIGHT: #ffffff 1px solid"><!-- report button -->
<!-- / icon and title --><!-- message -->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
</TD></TR></TBODY></TABLE>

 

[G2K]

check your cells/Textboxes/Combo boxes on beforesave event of workbook - if condition is true then save the file else exit sub,
check the password before saving the workbook

Clear desired cells/textboxes/combo boxes on workbook open event.

Hope this helps