It's not possible, since macros would have to be enabled to automate
closure.

What is often suggested is to have all sheets hidden except a "splash"
sheet, saying "you must enable macros to use this workbook." You could
then use a Workbook_Open() event to unhide the working sheets and hide
the splash sheet. Use a Workbook_BeforeSave macro to unhide the splash
sheet, hide the working sheets, save the file, then reverse the process
again. You can set the visibility of the working sheets to xlVeryHidden
to prevent them from being listed in the Format/Sheet/Unhide dialog.

Note that this will only be a convenience to your users, not provide any
real security. Anyone with enough ability to find these newsgroups will
be able to find ways to bypass your protection scheme.





In article ,
"Graham Fowler" wrote:

Is it possible to close a workbook if the user does not enable macros. If
so, how would this be achieved? Any help would be very much appreciated as
it is important that my user cannot bypass enableing macros.