Leith,
Thank you much for your response.
I replaced my code with your and when I tried closing the workbook I received a Run-time error '91': Object variable or With block variable not set.