Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Running XY chart labeller using a macro's parameters and arguments.
Hi,
I recently got hold of Ron Bovey's XY chart labeler (http://appspro.com/Utilities/ChartLabeler.htm) . I want to do labeling using a macro. I would like to pass the arguments, the location of a chart (name of the chart object and within which worksheet/chartsheet it is located) and the range to be used for labeling, using a macro. Dont want any manual prompting for indicating the same. I did go through Ron's subs (the project is unprotected) and there were four subs and the second sub "Mnetrypoints" seemed to be the workhorse. But it doesnt use any arguments and it invokes the Form etc. Please guide me if possible. Thanks a lot, Hari India |
#2
|
|||
|
|||
Hi,
Im sorry thats Rob Bovey's add-in and not Ron Bovey. Thanks a lot, Hari India "Hari Prasadh" wrote in message ... Hi, I recently got hold of Ron Bovey's XY chart labeler (http://appspro.com/Utilities/ChartLabeler.htm) . I want to do labeling using a macro. I would like to pass the arguments, the location of a chart (name of the chart object and within which worksheet/chartsheet it is located) and the range to be used for labeling, using a macro. Dont want any manual prompting for indicating the same. I did go through Ron's subs (the project is unprotected) and there were four subs and the second sub "Mnetrypoints" seemed to be the workhorse. But it doesnt use any arguments and it invokes the Form etc. Please guide me if possible. Thanks a lot, Hari India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with running Macros | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
HELP - Running Macros in VBA | New Users to Excel |