I have my workbook set so that you can not open it
without enabling macros with;

Private Sub Workbook Open ()
This Workbook.IsAddin = False

It works great except when I close the file, using a
dialog box. If I select "Save & Close" it saves and
closes the file but it sets the workbook so that you can
now open without enabling macros.

If I use the normal Excel Close, it can not be opened
without enabling macros.

Any ideas on what is happening?

Thanks