On Jan 22, 12:33*pm, Don Guillett wrote:
On Jan 22, 5:31*am, dave wrote:

I need VB code to execute the form straight away when the file is open
instead of click the button on the sheet to execute the form. Any
solution?

Thanks

dave

Look in the ThisWorkbook module for workbook_open

Cheer Don. It work. Can you help with 1 more formula. I want the work
book to be closed when press the close button. Do you know what is the
formula?

Thanks

Dave