| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Out / Check In
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check Out / Check In
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check Out / Check In
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| Loop through column(s) to check values, perform action based on check | Excel Programming | |||
| Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
Hybrid Mode
