Check Out / Check In

[PatK]

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

 

[Mike H]

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]

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

thanks,
Patk