Is there a way to write code that would automatically check out a document
upon opening (assuming it is not already, and of so, Warn), and then check it
in upon close?

And where would this code have to go? It would not be in a sheet, but
somewhere where code can be placed that executes upon open/close.

Ideas?

Patk

you could use the open & close events.
Alt+F11 to open VB editor. Double click 'This workbook' and paste the 2
modules below in on the right.

Private Sub Workbook_Open()
'Check things
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'Check things again
End Sub


Mike

"PatK" wrote:

> Is there a way to write code that would automatically check out a document
> upon opening (assuming it is not already, and of so, Warn), and then check it
> in upon close?
>
> And where would this code have to go? It would not be in a sheet, but
> somewhere where code can be placed that executes upon open/close.
>
> Ideas?
>
> Patk

Thanks! Seems simple enough. Any idea on the code that goes in between? Is
that as simple (or even possible)?

thanks,
Patk

"Mike H" wrote:

> you could use the open & close events.
> Alt+F11 to open VB editor. Double click 'This workbook' and paste the 2
> modules below in on the right.
>
> Private Sub Workbook_Open()
> 'Check things
> End Sub
>
> Private Sub Workbook_BeforeClose(Cancel As Boolean)
> 'Check things again
> End Sub
>
>
> Mike
>
> "PatK" wrote:
>
> > Is there a way to write code that would automatically check out a document
> > upon opening (assuming it is not already, and of so, Warn), and then check it
> > in upon close?
> >
> > And where would this code have to go? It would not be in a sheet, but
> > somewhere where code can be placed that executes upon open/close.
> >
> > Ideas?
> >
> > Patk