Sol,
If you have the alternative of doing this on a windows box you could have a
look at the Chart Browser in my XspandXL add-in:
http://www.enhanceddatasystems.com/E...pandXLHome.htm
Robin Hammond
www.enhanceddatasystems.com
"Sol Apache" wrote in message
...
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?