|
PureBytes Links
Trading Reference Links
|
Walter,
Your posts are always chucked full of great information and I only wish I knew
what the other side of this conversation, as an example, stated. You are
obviously answering someone specific on the list but since you usually do not
include the original, I am usually at a loss and miss out on another nugget of
your wisdom once again!
I really do wish, fervently (hyperbole), that you would, as a matter of course,
hit the reply button, so I, we, would be able to benefit from both sides of the
exchange.
Respectfully (really),
Dan (part of the ten percent that is always the last to hear)
W Lake wrote:
> Hi
>
> In the workbook you might want to look for hidden sheets and hidden columns.
> In this case there are many hidden columns filled with in-cell code and
> named ranges. One sheet has over 100 hidden columns. Watch out for text that
> is the same colour as the background. Use the map that you mentioned to
> find and change the colour of the fonts.
>
> The VBA code makes regular references to the named ranges in the hidden
> columns. So if you want to modify the code you will need to see the in-cell
> code and named ranges that you are referring to.
>
> Delete the surface "junk" boxes and record or write your own code for the
> subs/macros that are insufficient.
>
> The modules are isolated so debugging is very easy if you comment your
> changes and make notes in text boxes on each sheet that you change. You'll
> learn a lot from the workbook.
>
> An xll is different from a dll so it may not be visible in the same way. Let
> me know if you have any luck.
>
> Best regards
>
> Walter
|