Re: prevent user input question
Re: prevent user input question
- Subject: Re: prevent user input question
- From: Paul Berkowitz <email@hidden>
- Date: Sat, 03 Nov 2007 17:46:00 -0700
- Thread-topic: prevent user input question
On 11/3/07 12:47 PM, "Shane Stanley" <email@hidden> wrote:
>
>> How does scripting Excel directly prevent user input while the script
>> is executing?
>
> It doesn't, but it makes it much *less* susceptible to problems. You can
> keep it in the background, for example, and people can do other stuff in
> other apps without problem.
Another thing you can do - preferably after putting it in the background by
activating the Finder or another app - is to
tell app "Microsoft Excel"
set screen updating to false
[your script here]
set screen updating to true
end tell
That makes it much faster, and it ignores what's in the UI while it's
running, then shows results at the end. Hopefully, it might even ignore and
undo changes made in the UI in the same worksheet while it's running. (You
could also bring another worksheet to the front of Excel for the duration of
the script to discourage user interference.)
--
Paul Berkowitz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden