What I would like to do is if there has been no activity on the workbook for
10 minutes it will save and close automatically. Any pointers most
appreciated.

Taffy

Paul B. gave you code to do what you asked, but I'd be a little careful
implementing this.

If I open a workbook and make a bunch of changes and realize that I don't want
to save the changes, you're code will save it when it closes. This could be a
mild irritant or a big old problem--depending on how much stuff was lost.

And closing without saving represents the opposite end of the spectrum. If I
spend 8 hours making changes without saving and your code closes without saving,
you might have a disgruntled user chasing you.

Whatever you do, make sure your users know what's going to happen.




Taffy wrote:

What I would like to do is if there has been no activity on the workbook for
10 minutes it will save and close automatically. Any pointers most
appreciated.

Taffy

--

Dave Peterson

Paul B thanks, does exactly what it says on the tin.

Dave, thanks for the comments. The workbook is being used by three
different people in different buildings. They only have to enter a number
and print of a chart each day, should hear the moaning when one of them
leaves the workbook open.

More help

Is it possibe to have a message box open 30 seconds before closing the
workbook MsgBox "This workbook will auto-close in 30 seconds"
with a OK and Cancel button with a timer ticking down?

This message box should come to the front of all open windows.

Or should this be in a new post?

Thanks Taffy

You could do this code (from Jim Rech):

Sub SelfClosingMsgBox()
CreateObject("WScript.Shell").Popup "Hello", 30, _
"This closes itself in 30 seconds"
End Sub

I tested it by running this:

Sub aaa()
Application.OnTime Now + TimeSerial(0, 0, 20), "selfclosingmsgbox"
End Sub



It popped up over other windows in my test--win98, though. I'm not sure how all
versions of windows will handle it.



Taffy wrote:

Paul B thanks, does exactly what it says on the tin.

Dave, thanks for the comments. The workbook is being used by three
different people in different buildings. They only have to enter a number
and print of a chart each day, should hear the moaning when one of them
leaves the workbook open.

More help

Is it possibe to have a message box open 30 seconds before closing the
workbook MsgBox "This workbook will auto-close in 30 seconds"
with a OK and Cancel button with a timer ticking down?

This message box should come to the front of all open windows.

Or should this be in a new post?

Thanks Taffy

--

Dave Peterson