Why have you split the code across 4 posts? Firstly it is attempting to create a commandbar which are no longer supported in Excel 2010. Attach a workbook with the code in