Hello Jewel,

I have 2 questions:
1.) While saving the workbook I get a popup message to save it in .xlsm format. Is there any way where the macro can work in .xlsx format?
2.) When running the macro I am getting a 'Run-time error "438": Object doesn't support this property or method' and the following code gets highlighted yellow in macro "For Each ws In Me"
3.) Is this macro compatible with MS Excel 2010.

Appreciate your time and response. Thank you.

Adi.