Names in worksheets




Identifiers that are identical to named worksheet ranges AND ALSO OCCUR in strings
will not be camouflaged.

If the affected identifiers are to be camouflaged, then rename these
or the worksheet ranges.


The options to camouflage identifiers specify that certain types of identifiers
can also occur within strings, and that they have to be camouflaged
because they are references to VBA objects (procedures, etc.).

Access to worksheet ranges can also occur using strings (e.g. Range("Print")).

If a string identifier has the same name as a named worksheet range,
this identifier may not be camouflaged or else
the worksheet range can no longer be accessed.


An example should illustrate that:

There is a named worksheet space 'X_Values' as well as the following source–code positions:

(1) Sub X_Values()
...
End Sub

...
(2) Application.OnKey "%x", "X_Values"
...
(3) Worksheets(1).Range("X_Values").Clear

(1) declares a procedure 'X_Values'.

In (2) this procedure is assigned to Alt+X.
Therfore the identifier 'X_Values' has to be placed within a string.

In (3) 'X_Values' is also used in a string,
but this time as a reference to a worksheet space.

To camouflage (1) the identifier 'X_Values' is replaced by a masked name.
This is repeated at (2).

However, at (3) 'X_Values' must not be changed
or else the reference to the range would be lost.

To avoid possible mistakes,
identifiers that

– have the same name as worksheet ranges
  AND
– occur within strings

are NOT camouflaged by CrunchCode.


Note that identifiers that are identical with named worksheet ranges but are NOT used
in strings are in any case camouflaged as long as no other exceptions are defined.

(CrunchCode works only WITHIN a VBA project.
Named ranges, worksheet registers, formulas etc. remain unchanged!)



Handling of the list:

The list is sorted on the column whose header is highlighted.
To sort on another column, click on its header.
Clicking on the same header a second time reverses its order.

double click: display position in the source–code

The selection of entries can also happen with:

Letter/number: Next list entry that begins in the sort column
with the respective characters
 ------ xxx
Ctrl + Space: Next group in the sort column | xxx
 -----> yyyy
yyyy