It won't show up in the macro list, because it requires parameters to be
passed, this stuff:

(chParent As Variant, chSubChart As Variant, _
Optional dSubHeight As Double)

Call it from within another sub or from the Immediate window, providing
values for the parameters.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


M H wrote:

Hi Robin,
Thanks for the code, but I couldn't run it when I pasted them into VBE.
It simply didn't show up in the macro list, even after corrected a
couple of typing errors.
Nice to meet you. BTW, are you also in HK?
Maurice



*** Sent via Developersdex http://www.developersdex.com ***