Yes that was the first thing I tried. For some reason, Excel 2007
would not record the macro. Has anyone else been able to record it?
On Oct 5, 9:45 am, hari kumar wrote:
> On 10/5/09, Paul Schreiner wrote:> Have you tried
> recording a macro and then doing
> > these steps?
>
> > P
>
> >Hi Son
Hi everyone,
How to handle pivot table and pivot chart using VBA
please can you send me attachment for this
==
Jai Deo Tiwari,
Bangalore - 38
==
--~--~-~--~~~---~--~~
--
What I'm trying to achieve:
I'm creating an index file, fill it with the items in a certain folder
and link from the index file towards the correct items, now this
worked fine in powerpoint 2003, but for some reason in 2007 it stops
at this code:
--
With objShapes(objShapes.Count)
On 10/5/09, Paul Schreiner wrote:
> Have you tried recording a macro and then doing
> these steps?
>
> P
>
>
>Hi Sonny,
Go to tools> macros> recod new macro>
you can right click on a Data
> Series. then select Format Data point. The on the right, select
> Border Styles. Within this, there's a wa
Have you tried recording a macro and then doing
these steps?
P
From: Sonny
To: MS EXCEL AND VBA MACROS
Sent: Monday, October 5, 2009 8:55:18 AM
Subject: $$Excel-Macros$$ Excel 2007: How can I use VBA to set series border
line width?
After making a chart in
After making a chart in Excel 2007, you can right click on a Data
Series. then select Format Data point. The on the right, select
Border Styles. Within this, there's a way to set the width: say to
0.25 pt.
That's the GUI way of doing it, how can I change this width using VBA?
--~--~-~--
Thank You Paul
Regards
Umesh Dev
On Thu, Oct 1, 2009 at 7:40 PM, Paul Schreiner wrote:
> A "Class" is a way of defining a new object and attributes.
>
> let's say you wanted to create an object called "People".
>
> Now, for each person in "People" you wanted to save the
> Name
> Address
> City
It looks like I spoke too soon.
I have code that will delete VB modules
and import vb modules,
but it cannot protect/unprotect the VBProject.
I took a look around the internet and from all
posts I've seen, it can't be done with VBA "directly".
However, you CAN use SendKeys,
but that would mean th
A Google search for:
"excel vba read interior color rgb"
returned Chip Pearson's site at Pearson Software Consulting, LLC:
http://www.cpearson.com/excel/colors.aspx
He's got examples and functions for returning the RGB values
for a cell.
hope this helps.
Paul
___
