Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
Is there a way to save and close a spreadsheet when there has been no
activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
One way described he-
http://www.ozgrid.com/forum/showthread.php?t=32949 Mike "Steve" wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
Thanks Mike
Appears to work just fine, after some playing as to where to put some of the subroutines "Mike H" wrote: One way described he- http://www.ozgrid.com/forum/showthread.php?t=32949 Mike "Steve" wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
Steve,
The first thing might be to see of your network software has the timed shutdown you need. Doing it with Excel will require a macro, and the user will have the option upon opening to disable macros (presuming you have the macro security set high enough, as you should). -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "Steve" wrote in message ... Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
Is this a good idea?
Will your close routine save or cancel the outstanding changes? How would you know if you'll cause the user hours and hours of work by saving something that shouldn't be saved--or discarding something that should be saved? Steve wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
Hi Dave
These are data input spreadsheets that will be used on several workstations. This is an attempt to avoid the problem of a user leaving the spreadsheet open and walking away or going to luch or home. I know the Excel is not the best multi user environment but it is all we currently have. We analyze the data later. "Dave Peterson" wrote: Is this a good idea? Will your close routine save or cancel the outstanding changes? How would you know if you'll cause the user hours and hours of work by saving something that shouldn't be saved--or discarding something that should be saved? Steve wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
I understand the problem. But I'd be worried that the solution was worse than
the problem. Steve wrote: Hi Dave These are data input spreadsheets that will be used on several workstations. This is an attempt to avoid the problem of a user leaving the spreadsheet open and walking away or going to luch or home. I know the Excel is not the best multi user environment but it is all we currently have. We analyze the data later. "Dave Peterson" wrote: Is this a good idea? Will your close routine save or cancel the outstanding changes? How would you know if you'll cause the user hours and hours of work by saving something that shouldn't be saved--or discarding something that should be saved? Steve wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
Hi Sandy
We do not let the users get into Edit mode, but thanks for the caution. "Steve" wrote: Hi Dave These are data input spreadsheets that will be used on several workstations. This is an attempt to avoid the problem of a user leaving the spreadsheet open and walking away or going to luch or home. I know the Excel is not the best multi user environment but it is all we currently have. We analyze the data later. "Dave Peterson" wrote: Is this a good idea? Will your close routine save or cancel the outstanding changes? How would you know if you'll cause the user hours and hours of work by saving something that shouldn't be saved--or discarding something that should be saved? Steve wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
So you are saying that the workbook is protected and that nobody can write
anything in this workbook and just look up info? If not then the workbook can definitely be in edit mode -- Regards, Peo Sjoblom "Steve" wrote in message ... Hi Sandy We do not let the users get into Edit mode, but thanks for the caution. "Steve" wrote: Hi Dave These are data input spreadsheets that will be used on several workstations. This is an attempt to avoid the problem of a user leaving the spreadsheet open and walking away or going to luch or home. I know the Excel is not the best multi user environment but it is all we currently have. We analyze the data later. "Dave Peterson" wrote: Is this a good idea? Will your close routine save or cancel the outstanding changes? How would you know if you'll cause the user hours and hours of work by saving something that shouldn't be saved--or discarding something that should be saved? Steve wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
Steve,
By "edit mode" I mean just be in the middle of entering something into a cell. So if you click into a cell and enter: Steve but don't press Enter, you will find that you cannot then run a Macro. So if someone leaves that sheet like that the closing Macro will not run. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Steve" wrote in message ... Hi Sandy We do not let the users get into Edit mode, but thanks for the caution. "Steve" wrote: Hi Dave These are data input spreadsheets that will be used on several workstations. This is an attempt to avoid the problem of a user leaving the spreadsheet open and walking away or going to luch or home. I know the Excel is not the best multi user environment but it is all we currently have. We analyze the data later. "Dave Peterson" wrote: Is this a good idea? Will your close routine save or cancel the outstanding changes? How would you know if you'll cause the user hours and hours of work by saving something that shouldn't be saved--or discarding something that should be saved? Steve wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Timed shutdown of spreadsheet
Gotcha
No way around that I guess. We'll just have to locate the offending computer Thanks "Sandy Mann" wrote: Steve, By "edit mode" I mean just be in the middle of entering something into a cell. So if you click into a cell and enter: Steve but don't press Enter, you will find that you cannot then run a Macro. So if someone leaves that sheet like that the closing Macro will not run. -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Steve" wrote in message ... Hi Sandy We do not let the users get into Edit mode, but thanks for the caution. "Steve" wrote: Hi Dave These are data input spreadsheets that will be used on several workstations. This is an attempt to avoid the problem of a user leaving the spreadsheet open and walking away or going to luch or home. I know the Excel is not the best multi user environment but it is all we currently have. We analyze the data later. "Dave Peterson" wrote: Is this a good idea? Will your close routine save or cancel the outstanding changes? How would you know if you'll cause the user hours and hours of work by saving something that shouldn't be saved--or discarding something that should be saved? Steve wrote: Is there a way to save and close a spreadsheet when there has been no activity for a particular amount of time? We have a problem with several users needing access to the same workbook. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timed message box | Excel Discussion (Misc queries) | |||
TIMED MSGBOX | Excel Discussion (Misc queries) | |||
excel shutdown | Excel Discussion (Misc queries) | |||
timed macro | Excel Worksheet Functions | |||
UPS Shutdown script | Excel Discussion (Misc queries) |