LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Line Gradient in Excel 2007

One general method of figuring out how something is done in VBA is to do
it in excel while recording a macro and then studying the macro.


That is true generally but FYI in Excel 2007 few, if any, actions taken on
shapes are recorded by the macro recorder. For example this is the code
recorded when I changed the fill color of a selected rectangle from blue to
red in Excel 2007:

Sub Macro1()
'
' Macro1 Macro
'
End Sub

MS made extensive changes to shapes in Excel 2007 and recording with regard
to them was broken. They told beta testers that they'd like to restore it
in a later version.

--
Jim
"Alok" wrote in message
...
| Shahin,
| As far as I know you cannot apply a gradient to a line. It has to be a
solid
| color.
| One general method of figuring out how something is done in VBA is to do
it
| in excel while recording a macro and then studying the macro.
| Happy new year.
| Alok
|
| "Shahin.H" wrote:
|
| Happy new year everybody,
| I would like to write a macro in EXCEL 2007 (in year 2007 ;) ) to change
| line fill gradient. Suppose, I have a shape which has a fill gradien
color
| and its border has a gradient line color (NOT solid color). So, I wonder
I
| can change gradient line color by writing such a macro? I know this is
| possible to change gradient fill color of shapes in Excel 2007, but I
haven't
| find anything for gradient line color in VBA programming.
|
| I would be very grateful if anybody could help me.
|
| Best regards,
| Shahin.H
|


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change gradient color in chart for Excel 2007 NonTechie Charts and Charting in Excel 6 May 9th 23 03:43 AM
How do I select two colors for Gradient Fill Excel 2007 Hennie[_2_] Charts and Charting in Excel 1 August 14th 09 09:15 AM
Charts - Gradient fill Plot Area in Excel 2007 Geoff Budd Charts and Charting in Excel 4 February 4th 09 05:44 PM
Were non-gradient chart patterns left out of Excel 2007? Arthur Tabachneck Charts and Charting in Excel 2 August 28th 07 01:58 AM
Are the non-gradient chart patterns missing from Excel 2007? Art[_3_] Excel Worksheet Functions 1 August 27th 07 10:37 PM


All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"