Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a file that only allows one user at a time to have write/update
authority (first one in locks it up); there are five people with this modification authority. The problem is one of them opening it and then walking away for an extended period of time and thus the others cannot input their updates. I do not want to make it into a shared file. Similar to my company's auto password protected screen saver (kicks on after "x" number of inactive minutes), I would to have the file save itself and close if a write/update user hasn't navigated in the file via keyboard or mouse in say the last three minutes. Ideally, anyone who opened the file with €śread only€ť clearance (approximately a dozen users preset as Read Only) would not get €śkicked out€ť as they are not disrupting anyone. Any clues / insight? Regards, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent users from changing the password | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
How many users can sucessfully use a shared excel workbook? | Excel Worksheet Functions | |||
How do I allow users to make a choice in a worksheet? | Excel Worksheet Functions | |||
Protecting Workbook | Excel Discussion (Misc queries) |