ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to open a macro? (https://www.excelbanter.com/excel-programming/359920-how-open-macro.html)

Mark Milke

How to open a macro?
 
Hi!

I have an excel file. When I open it, it asks if I want to activate the
macros, which I do want. Now I want to view or change that macro, but I
can't find it in excel in the macro list. Where else can I look?


Mark


Ivan Raiminius

How to open a macro?
 
Hi Mark,

your macro might be a function or it expects some input, so it doesn't
appear it the Excel run list. Press ALT+F11 to enter Visual Basic
editor and you should be able to find it in one of the modules of the
project.

Regards,
Ivan



All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com