|
PureBytes Links
Trading Reference Links
|
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
|