What processes/cells/macros are calling/using the hidden workbooks

Posted on 2012-08-29
Last Modified: 2012-09-21
I have inherited a bunch of Excel workbooks,   some of which have many hidden workbooks.
How do I find what is using a hidden workbook  in a Excel workbook?
There are many long macros.
Is there a tool for documenting the data flow betwixt the workbook & hidden workbooks within excel?
Question by:AndyPandy
    LVL 10

    Accepted Solution

    References to the hidden worksheets are likely of the form: Sheets("HiddenSheetName"). You can open the Visual Basic Editor and search for the sheet name.
    LVL 10

    Expert Comment

    (That posted before I was finished.) Be sure to set it to search the Current Project.
    Find within project

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now