Hi all

I have a macro that applies a user-defined chart template to a basic chart.
Ideally I would like to be able to do one of the following:

1. Take a constant/variable that contains the name of the template and
compare this against a list of available user-defined templates to see if it
exists.

and/or

2. Create a user form (which I think I can do) that is basically a stripped
down version of the xlDialogChartType dialog box and just contains a list of
available user-defined templates for the user to select. I would prefer not
to use the 'official' dialog box as it involves clicking through several tabs
to get to the user-defined list (unless you can get it to display that
straight away of course)., which may not seem like too much of a chore but
the users will be running this a lot so it will get frustrating.

Thank you for any help

Andy