Stargazer
09-09-2010, 08:52 AM
Hiya,
We've developed a countdown clock that closes a workbook after 3mins of inactivity. It works great, except for one small problem... the clock stops ticking down if the user leaves puts any workbook cell into edit.
Said user then leaves a cell in edit, goes away from her desk for an hour and in the meantime nobody else can access the file to be allocated new orders for validation.
The Workbook ust not be shared because the idiots I work for would just blunder about and ruin it without realising they are breaking it. At least if only one person can run it at a time, it minimises the potential damage done significantly.
To get back to the subject at hand, we beleive that if we can run the clock independantly in a separate application window, it won't be subject to the cell edit problem.
On file launch, we plan for our file (that we've nick-named Nova) to open and display a splashscreen. While the user is admiring our logo, Excel will call the countdown timer file into a new window which is rapidly hidden leaving behind only a small userform. This we can do.
What we can't do is tell Nova to reset the countdown clock on a button press, nor can we get the countdown clock to close Nova. We've made the discovery of the fabulous AppActivate function, but merely selecting the destination window isn't enough.
Can anyone here tell us if it is possible (and if so how) to manipulate a workbook opened in a seperate excel application window?
And and all help is greatly appreciated.
Thanks in advance,
Rob.
We've developed a countdown clock that closes a workbook after 3mins of inactivity. It works great, except for one small problem... the clock stops ticking down if the user leaves puts any workbook cell into edit.
Said user then leaves a cell in edit, goes away from her desk for an hour and in the meantime nobody else can access the file to be allocated new orders for validation.
The Workbook ust not be shared because the idiots I work for would just blunder about and ruin it without realising they are breaking it. At least if only one person can run it at a time, it minimises the potential damage done significantly.
To get back to the subject at hand, we beleive that if we can run the clock independantly in a separate application window, it won't be subject to the cell edit problem.
On file launch, we plan for our file (that we've nick-named Nova) to open and display a splashscreen. While the user is admiring our logo, Excel will call the countdown timer file into a new window which is rapidly hidden leaving behind only a small userform. This we can do.
What we can't do is tell Nova to reset the countdown clock on a button press, nor can we get the countdown clock to close Nova. We've made the discovery of the fabulous AppActivate function, but merely selecting the destination window isn't enough.
Can anyone here tell us if it is possible (and if so how) to manipulate a workbook opened in a seperate excel application window?
And and all help is greatly appreciated.
Thanks in advance,
Rob.