Assuming there is a macro in (or accessible to) the workbook, it can usually be accessed via Alt-F8 or via the Developer tab on the Ribbon. Some macros are not accessible that way, however.
If you want to see the code for macros irrespective of whether they're visible through the user interface, press Alt-F11 to access the VB environment (VBE). Do note that, depending on whatever security measures the macro's creator might have implemented, you might need to supply a password. Macro (VBA) code can be located in code modules, a ThisWorkbook module, WorkSheet modules, and userform code modules. All of these modules (if they exist) are usually visible on the left side of VBE.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.