Billbo wrote:Further to my last post
on delving further into the program I find any code relating to color gives me a compiler error!
Sould I delete there also?
Are you using the .xlsm version (Excel 2010 ONLY), or the .xls version (all Excel versions)? For Excel 2003 you'll want the .xls version.
I added version detection to skip over the parts that cause problems in the older versions.
Otherwise, Yes, just comment out (or delete) the lines causing problems. They are just shading in the routing area, nothing vitally important.