Excel Macro

[iambob]

Where is the Excel Macro located? Does anyone know how to access it? Or do I have to code to get into it?

Sincerely,
Bob Space

 

[mintjulep]

The Excel macro is usually located in the Excel file.

But it is possible to save it on its own file.

 

[macropod]

Where is the Excel Macro located? Does anyone know how to access it?

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.

Cheers
Paul Edstein
[Fmr MS MVP - Word]

 

[iambob]

Thanks guys! Very helpful. Sorry for the late reply.

Sincerely,
The Thunderbird