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 13:15:02 -0700
- Thread-topic: prevent user input question
On 11/3/07 12:57 PM, "Paul Berkowitz" <email@hidden> wrote:
> 'protect workbook' at the beginning of the script (with 'unprotect' at the
> end) *should* be able to prevent user input for the duration. But it doesn't
> seem to be working - a bug.
But 'protect worksheet' is working OK:
tell application "Microsoft Excel"
protect worksheet active sheet
--your script
unprotect active sheet
end tell
.. With or without the 'password' parameter.
However, it also protects the worksheet from your script too (although
thankfully does not bring up the "Protected" dialog). Back in VBA days, the
equivalent of the 'user interface only' parameter got around that
encumbrance for macros, But its function has not been transferred to
AppleScripting, as it should do. Using it does nothing - the sheet is still
protected from your script commands. I'll report that (and the workbook bug
too).
--
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