File Saving Option

[Loopty]

I'm assuming there is a way to do this, but I can't find
information in it; I'd like to create a spreadsheet that
will prevent a user from saving/closing without first
inputting data into pre-assigned cells (these cells use
different font settings). Basically, they'll receive an
error message for not updating all required info (about 10
cells worth of data).

Thanks!

 

[Don Guillett]

In a regular module create your code
sub ifnot()
if range("a1")="" then msgbox "Complete range a1 on that sheet.
etc
end sub

then in the ThisWorkbook module before_close AND before_save events insert
call ifnot