Dave, why does your sub work when added to a regular module, but not
to"ThisWorkbook"?

- David

Dave Peterson wrote:
Have you thought about putting the same kind of routine in the workbook_open or
auto_open procedures.

Then you don't have to bother the person closing the workbook with any prompt or
a reminder to save.

Option Explicit
Sub auto_open()
ActiveSheet.Select
End Sub

Holly wrote:
Is it possible to prompt an alert upon exit of a worksheet alerting the user
that the worksheets are being saved with grouping on?