Hi Jan

but there is problem in open the file
when i want to open the file the file giving the error and automaticaly
close the excel



"Jan Karel Pieterse" wrote:

Hi Ani,

yes
few of the sheets contain macro


If you select all worksheets (click first, hold shift and click last
tab) and copy them to a new workbook (rightclick tab, select move or
copy, choose "New workbook" from the dropdown) and save that new file
(use a different name!), does the problem go away?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com