On 5/23/09 7:47 PM, "John Duncan" wrote:

> I worked out a solution that functions but is very slow so if anyone
> has a better method I'd appreciate seeing it ...
> 
> tell application "Microsoft Excel"
> tell workbook 1
> tell worksheet 1
> set theOptionButton to every option button whose name is
> "options_yesno" and caption is "Yes"
> set the value of item 1 of theOptionButton to checkbox on
> end tell
> end tell
> end tell

Can you limit to checking a range, rather than the entire worksheet?

tell application "Microsoft Excel"
tell range "A1:Z500" of worksheet 1 of workbook 1
set theOptionButton to every option button whose name is "options_yesno" and
caption is "Yes"
set the value of item 1 of theOptionButton to checkbox on
end tell
end tell

Stan C.