Macro to show all references to a worksheet

[NitinChaswal]

Hi Forum
Need help. Sometimes a particular worksheet needs to be deleted from the workbook when it no longer is needed. I got tired of manually checking out all the references that sheet has from other worksheets and also which sheets are referring to the current sheet so I can remove those references & delete the sheet to without irritating #REF errors all over my financial model. Specifically I want to know:-

1.) Which all sheets in the workbook are referenced in the active sheet
2.) And which all sheets are picking up data (or have references) from active sheet.

Can anyone help me with the Macro ?
One macro or two macros can do the job I suppose.

 

[dchaney]

Not sure if this is what you are looking for or not, but check out this link

 

[NitinChaswal]

Thank you dchaney. But this is helping me find which all sheets are referred to in current sheet. I also, & more importantly, want to know how to find which all sheets are referring to the current sheet so I can easily de-link those references before deleting a worksheet. I just want to avoid the #REF errors encountered after deleting a sheet.

Any ideas?