S
Sol Apache
I have created a macro which reformats a chart (removes the unwanted black
border which comes with the user-defined chart), then I resize it to the
size I want. 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 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 it 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
border which comes with the user-defined chart), then I resize it to the
size I want. 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 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 it 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