Database saving

[Guest]

I have created a work book with 3 label sheets and data tracking sheet to
allow an operator on the plant floor to print labels for the product.
Currently all common information on the labels is linked but the operator has
to enter all the data into the fouth sheet. I have set up a database in excel
to save the information from the labels and have tried using a macro to
allow the operator to print the label and save the information into the
database without having to hit the save button. but when i exit the workbook
it always asks if i want to save the information into the database. I would
like to make this transparent to the operator.
Is there a way to simplify this process so all the operator has to do is
use either a button or key combination to print and add a new record to the
database

 

[Frank Kabel]

Hi
you could add some code to the workbook_beforeclose event and save the
workbook automatically at this point

 

[Guest]

Will that also save the data into the database without asking the operator to
either "edit existing data", "add as new record", or "exit without saving"?