Check Out / Check In

  • Thread starter Thread starter PatK
  • Start date Start date
P

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
 
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
 
Thanks! Seems simple enough. Any idea on the code that goes in between? Is
that as simple (or even possible)?

thanks,
Patk
 
Back
Top