|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
12-08-2003, 04:37 AM
|
#1 |
|
Member (8 bit)
Join Date: May 2000
Location: Manila
Posts: 194
 |
Time Limit for Excel?
Is there a way I can have a time limit on editing my Excel files? Let say I wan't other user to make changes at certain times only or once it reaches a certain time it would restrict everyone from making changes.
Thanks |
|
|
|
12-08-2003, 05:31 AM
|
#2 |
|
Member (6 bit)
Join Date: Dec 2003
Location: Derby
Posts: 44
|
What operating system are you running?
|
|
|
|
|
12-08-2003, 03:20 PM
|
#3 |
|
Member (8 bit)
Join Date: May 2000
Location: Manila
Posts: 194
|
Windows 2000 pro
|
|
|
|
|
12-08-2003, 03:48 PM
|
#4 |
|
Member (5 bit)
Join Date: Apr 2001
Location: New Mexico
Posts: 29
|
I think Wolf meant what office operating system you are using. Office 2000, XP, or new one.
|
|
|
|
|
12-08-2003, 10:55 PM
|
#5 |
|
Member (8 bit)
Join Date: May 2000
Location: Manila
Posts: 194
|
Office 2000
|
|
|
|
|
12-09-2003, 12:40 AM
|
#6 |
|
Member (11 bit)
Join Date: Aug 2002
Location: BC, Canada
Posts: 1,054
|
You could use Microsoft Visual SourceSafe to make sure that only one person can edit the file at a time and the latest version is always available. SourceSafe is supposed to integrate with Office.
|
|
|
|
|
12-09-2003, 02:19 AM
|
#7 |
|
Member (8 bit)
Join Date: May 2000
Location: Manila
Posts: 194
|
thanks for that Idea, but what I want is that when a certain time reaches it would only allow users to view but not edit.
Thanks |
|
|
|
|
12-09-2003, 02:05 PM
|
#8 |
|
Member (10 bit)
Join Date: May 2000
Location: New Zealand
Posts: 546
|
You could do that in VBA if you are comfortable with using it.
You can pick up the user name from what is stored in excel, or direct from Windows by using a Win API call, or by creating your own 'login' within excel. Then just lock or unlock the model based on the user and the time. Be aware that excel takes its time from the system clock of the processor that is running the instance of excel - easy to fiddle with that. It may be possible to pull a time from another source I guess but I've never heard of anyone needing to. Just do each bit one at a time, and use the MS excel newsgroups (programming) if you get stuck and need expert assistance. HTH, Alan. |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
