The thread I'd given link to is now solved. Levan can take a look there. Here's one of the post by user Calvin Gao
Hi Gerhard,
Thanks for your post.
For your issue that VBA code from Excel 2003 doesn't work in Excel 2010, you can consider using this tool to help you to check the code compatibility:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15001
I hope this helps.
Best Regards, Calvin Gao [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.