How to find all hidden vba and macros code

[Clarence Perdue Jr.]

Hello,

I have been download many excel files from the internet to learn from. I am curious about how to see any hidden vba code or macros

Thanks

 

[Hui]

Clarence

There is no such things as hidden VBA or Macro code
All VBA/Macro code is available via the VBE System accessed via Alt F11
Code may be locked so that you can't view it but it is all there.
If you goto the VBE System using Alt F11 you should see a window similar to this:



If you don't use Ctrl R to bring it up

VBA code can be in any of the objects in the
+ Microsoft Excel Objects (Workbook and Worksheet Objects)
+ Forms (User Forms)
+ Modules (VBA Subroutines and Function Code)
+ Class Modules (Class Modules)

You need to look in each of these and the sub objects

A workbook doesn't necessarily need to have all of the above objects and only may have one or more