Password-protected worksheets




CrunchCode must know ALL existing worksheet objects.
Although CrunchCode does not change any table contents (except possibly names of objects1),
but must be able to recognize all links between worksheets and VBA code.
This is only possible if the worksheets are all visible and not password protected.

Such links may, for example, be:

– define functions that are used in worksheet formulas
– references to worksheet objects (e.g. Charts("Sales").ChartTitle.Text = "January")
– references to named ranges (e.g. Worksheets("Tab1").Range("StartVal").Value = 1)
  etc.

In such cases, the appropriate identifiers must NOT be camouflaged,
or else the connection to the worksheet objects and functions will be lost.


You can for exceptions exclude individual tables from this processing.
Click for this on the appropriate name.

WARNING!

It is important that these excluded worksheets
have NO connections to the source–code.

If they do, this WILL RESULT IN RUNTIME ERRORS!


make visible

CrunchCode unhides all hidden worksheets.