Is there a way in VBA to cause a worksheet to display
when exiting the workbook.

Yes, put code like this in the ThisWorkbook module.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("fill_name").Activate
End Sub


HTH,
Merjet