The following table explains the items that appear on the "Procedures" worksheet. All information relates to the active workbook at the time Summarizer was run.
|
Item
|
Details
|
| Procedure Name
|
name of vba procedure (subroutine or function) or vba property procedure
|
| Type
|
either "Procedure", "Property (Get)", "Property (Let)" or "Property (Set)" (depending on procedure type)
|
| Number of Lines
|
size of subroutine or function (as measured in terms of lines of code)
|
| Code Module
|
name of module containing VBA code
|
| Declaration
|
full declaration of subroutine or function
|
If the active workbook contains no VBA procedures, the "Procedures" worksheet will be empty except for the following text: "Workbook contains no vba procedures"
Access to VBA denied for security reasons
You may see this message if you are using Excel XP or later and Summarizer is not able to access VBA code in the active workbook. If this happens, please refer to "Summarizer does not detect VBA code in the active workbook" for guidance on resolving the issue.
