I am using Excel 2004 (Mac) to create an Excel template for charts to be
copied into PPT and Word - all to be used on Windows.

I have created a macro which reformats a chart (removes the unwanted black
border which Excel automatically imposes upon user-defined charts), then I
resize the chart to the size I want (a choice of three sizes which the user
selects using a userform). This means I have to deselect the chart, hold the
shift key down to make the chart an object that can be resized.

The problem is that the recorded macro refers specifically to a worksheet
and a chart and in my recording I had to deselect the chart in order to hold
the shift key down.

I want the macro to work on any selected chart created in a
workbook based on this template. I also want it to go back to ordinary
selection again so I can copy the chart as a picture.

I have very rarely used macros in Excel, and so I know very little about the
process - except that recorded macros are quite difficult to use globally.

So I¹d very much appreciate any help on this problem.


Sol

PS Would it help if I provided the VB text I have created already?