N
N
NataliaCh2019-04-23 10:20:55
excel
NataliaCh, 2019-04-23 10:20:55

The macro works, but the code is not visible. How to see the code?

There is an excell file (.xlsm) in which the program works: generating random numbers in certain cells when saving the document. There was a need to make changes to the program. But I can't get the code out. There is a Developer tab, the option "Enable all macros (not recommended, it may run a dangerous program)" is selected. But the macro window is empty. And with Alt F11, an empty window also opens. Can you please tell me how to open the code?
Excel knowledge at the most primitive level.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
B
BasiC2k, 2019-04-23
@BasiC2k

You need to press Alt + F11, then double-click on the file name on the left. A password may be requested or a file structure tree (book, sheets, modules, forms, etc.) will open immediately. Then you need to double-click to sequentially select the elements of the structure. If the element has a code, you will see it. If there is no code, then it may be in another workbook, an add-on, or a personal workbook with macros.

A
Alexander Shilov, 2019-04-23
@tabbols95

Developer -> Visual Basic -> module -> * is also nothing?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question