Shaun,

I'm not up on macros, but try asking your question in the macro forum here:

http://www.mrexcel.com