To give a better description of what''s going on ... I close the document just fine then I reopen it. When it is reopened I can still see all of the previously entered information that was there before it was closed last time but then I click the enable macros button that appears below my excel ribbon and all the information is cleared.

The issue is that this defeats the purpose of clearing before close because the next user is still allowed to see all the information.

Why would a BeforeClose event only run when the document is reopened and macros have been enabled?