Re: Excel 2004 & text color
Re: Excel 2004 & text color
- Subject: Re: Excel 2004 & text color
- From: Hanaan Rosenthal <email@hidden>
- Date: Sun, 10 Apr 2005 17:22:26 -0400
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...
I also changed 'color index' with 'font color index'.
Hanaan
On Apr 9, 2005, at 10:13 AM, Larry McMunn wrote:
tell application "Excel_2004"
activate
--THIS DOESN'T WORK:
set color index of font object of used range of active sheet to 1
--THESE WORK:
set italic of font object of used range of active sheet to true
set bold of font object of used range of active sheet to true
end tell
I have tried all sorts of variations on the above line. Any thoughts,
anyone
_______________________________________________
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