Guys or girls;

I solved it.
I used the Application.OnTime method to trigger the procedure that must run
after the save.

Why was this important.

I have a workbook were different users have different views on that
workbook.
This means that not all of them can see all worksheets and that a user has
to log on to create his specific view.

When you close the workbook a self-created before close procedure runs to
check for a yes/no save or cancel.
If Yes the initial settings (one sheet visible) are restored before the book
is saved.
If No the book closes without save.
This works fine as the workbook has not been saved before and these initial
settings appear when a user opens the book again.
The latter is what always must be the case; when you open the workbook, only
the first sheet is visible.

But; when a user saves the book and goes on editing the tricky thing
appeared.
When he then wants to close the workbook without saving the initial settings
must be created again, but no editing may be saved.
That contradicts.

I realized that I can only create that situation when before saving the
initial settings are created and immediatly after
saving, the users specific settings are restored again.

So; I solved it this way.
Still, I'm eager to see if alternatives or better ways are available.

Thanks for the help.

---
Mark Rosenkrantz
---
Spreadsheet Solutions
Witkopeend 24
1423 SN
Uithoorn, Netherlands
---
E:
W: www.rosenkrantz.nl


"Spreadsheet Solutions" wrote in message
. ..
I know that this event does not excists, but I need one.
Does anyone know how to create or mimick such an event.

The reason is a bit complicated, but a hint in a good direction is
nonetheless very much appreciated.