Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Macro

Status
Not open for further replies.

iambob

Programmer
Apr 13, 2021
41
US
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
 
The Excel macro is usually located in the Excel file.

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

 
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]
 
Thanks guys! Very helpful. Sorry for the late reply.

Sincerely,
The Thunderbird
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top