[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2012-08-29
2
Medium Priority
?
199 Views
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?
0
Comment
Question by:AndyPandy
  • 2
2 Comments
 
LVL 10

Accepted Solution

by:
tdlewis earned 2000 total points
ID: 38346605
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.
Screen-Shot-2012-08-29-at-10.22..png
0
 
LVL 10

Expert Comment

by:tdlewis
ID: 38346614
(That posted before I was finished.) Be sure to set it to search the Current Project.
Find within project
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

834 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