|
PureBytes Links
Trading Reference Links
|
Hi,
at this link
(http://www.geocities.com/WallStreet/9245/)
you'll find some free interesting works in Excel,
stats & financial, and links to VBA code
(http://www.vb-bookmark.com/vba.html).
Good trading
gg
At 10:16 PM 06/02/2001 -0500, you 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
|