mvidas
06-27-2006, 01:25 PM
Hi everyone,
I was presented with an interesting question yesterday, and have had a lot of fun getting it working nicely. They had a workbook that is called out of windows scheduler with a workbook_open event in it, but wanted the ability to have users edit the workbook without holding shift to suppress events if they wanted to. This prompts the user (for x seconds) to see if they want to edit it, and if no one is around (at 3am when it is scheduled) it will proceed after the specified waiting period. If a user had opened it they can choose to edit the workbook before the event proceeds.
Might be a bit too involved to make a kb entry out of it, but it might prove useful to someone. I'd love it if anyone came up with an alternative way to do this or had any improvements/suggestions to the current one; I just wish I had an actual use for it as opposed to creating it for someone for free :)
As stated, suggestions/improvements welcome!
Matt
I was presented with an interesting question yesterday, and have had a lot of fun getting it working nicely. They had a workbook that is called out of windows scheduler with a workbook_open event in it, but wanted the ability to have users edit the workbook without holding shift to suppress events if they wanted to. This prompts the user (for x seconds) to see if they want to edit it, and if no one is around (at 3am when it is scheduled) it will proceed after the specified waiting period. If a user had opened it they can choose to edit the workbook before the event proceeds.
Might be a bit too involved to make a kb entry out of it, but it might prove useful to someone. I'd love it if anyone came up with an alternative way to do this or had any improvements/suggestions to the current one; I just wish I had an actual use for it as opposed to creating it for someone for free :)
As stated, suggestions/improvements welcome!
Matt