View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stuart[_22_] Stuart[_22_] is offline
external usenet poster
 
Posts: 1
Default Sheet Information

Is it possable to write a list of all the objects within a workbook and any
links that they may have with Macros (subs).

To explain the problem, I have a very important workbook that has been
written over many many years, it now contains about 300 macros running
around 20000 lines of code. Some of these macros are undoubtedly no longer
used, and before I delete any, I wish to check that they are not linked to
any buttons or objects anywhere within the workbook, I can easily check the
modules to see if they are called from other macros however I would like to
check that no button still points to them!