How to reenable macros upon exit of workbook so users are prompted to enable macros each and every time they open the Excel workbook

When opening your workbook in Excel 2010, I'm always prompted to enable macros. Also, why do you hide the sheets on Close when you are opening them on Open? The net result of not doing either would be to have the sheets show up, which seems to be what you want to have happen.

Trying to force users to enable macros so we can track who is using the spreadsheet.  That part of the macro only works if users enable the macro.  Users can bypass the tracking macro if they don't turn it on currently and still see the report data.  By hiding the additional sheets it will force someone to enable the macros to get to their report and thus track who opened it. :)

The code here seems to be tan expansion of your code. Give it a try.

That method doesn't work.  When you close out of the macro, it doesn't close all the way out of Excel and I have to right mouse click on Excel icon in the task bar to close the Excel otherwise you are left with a gray Excel shell with no "X" to close.  Not the cut/paste I was looking for but I'll see if I can monkey that code to work.

In testing my original macro - it was already doing what I needed even though it was no longer prompting me for the enable macros warning