View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
excel wonk excel wonk is offline
external usenet poster
 
Posts: 5
Default Checking Dependence Before Deleting Worksheet

Before deleting any worksheet tab, I want to find out if there's
anything that affects other worksheets. Any way to check for this
short of clicking every cell and using "Trace Dependents"?

I know the spreadsheet gives message that deletion may affect other
data, continue?

Any way to check this AND find out which cells are dependents used in
other worksheets? Thanks.