when iam opening an excel sheet along with my log sheet its getting hanged
and i am not able to use the new sheet opened
Repair Excel
http://support.microsoft.com/kb/820...
Tools > Options > Error Checking tab
Or,
Tools > Error checking
First, a posting tip... When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "How do I solve this?" we wouldn't be able to tell one question from another and the Archives would essentially be useless.
I have edited your subject line to make it more informative.
Second, we don't know anything about how you are using Excel, so we don't know what you mean by "opening an Excel sheet along with your log sheet".
Are you trying to open a new sheet in an already open workbook? Are you trying to open another workbook while a different workbook is already open? Something else?
The more details you provide, the better the chance that we can offer suggestions specific to your issue.
How To Post Data or Code ---> Click Here Before Posting Data or VBA Code