Auto_open in a general module is the key. Excel knows to look at for that name
(along with auto_close) and do something special.

If you want the same kind of thing under ThisWorkbook, you have to play be
excel's rules and use the _beforeclose (or _beforesave???) event.

It's kind of like Autoexec.bat when you turn on the pc--well, when you used DOS
a hundred years ago!

David Hilberg wrote:

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?

--

Dave Peterson