Fumei,

I have posted an apology on the VBAExpress forum for cross-posting (http://www.vbaexpress.com/forum/showthread.php?t=45553). The reason I posted here was I thought this was a Microsoft website, and that Microsoft programmers might pick up on this. Nevertheless, I was inconsiderate in cross-posting without letting you know. Just wasn't thinking.

I did come up with a workaround using CommandBars.FindControl, which I've shared on the linked address above. Actually, I had tried it before but just didn't follow through on it.



Thank you. All the best!

As to the msofficeforums forum, my apologies to you also - please consider this post closed.