pass parameters to a sub in the macro editor

[ali_hijazi]

Hello

I got a macro that prints a bar chart with x-axis scroll bars

I want to pass the ID of the chart as parameter since the same macro can be used to print several charts with x-axis scroll bars

Please advise

[giakoum]

I guess that you use a button for each object you want to export. So define the ID as a variable using an action and then run the macro and read the variable with the following command :

set vID = ActiveDocument.Variables("ID")

Hope this helps!