Re: Excel 2004 & text color
Re: Excel 2004 & text color
- Subject: Re: Excel 2004 & text color
- From: Paul Berkowitz <email@hidden>
- Date: Sun, 10 Apr 2005 16:42:15 -0700
On 4/10/05 2:22 PM, "Hanaan Rosenthal" <email@hidden> wrote:
> Larry,
> try to address the range object in a tell block:
>
> tell application "Microsoft Excel"
> tell used range of sheet 1
> set font color index of font object of it to 1
> end tell
> end tell
>
> I'm not sure why this works and a direct command to the object
> doesn't...
Sure it does:
tell application "Microsoft Excel"
tell used range of sheet 1
set font color index of font object to 7
end tell
end tell
tell application "Microsoft Excel"
set font color index of font object of used range of sheet 1 to 4
end tell
both work. All it needed was the change to 'font color index', which is the
name of the property. Or what did you mean by a "direct command"?
--
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:
This email sent to email@hidden