Where are Macros stored?

[smorgan]

Silly question, but where are Macros stored? Are they stored just in
the worksheet, or are they stored locally on the machine?

Thanks!

 

[Guest]

When you create a macro you choose whether to store in the current workbook
or in the Personal workbook. If they are stored in Personal they are
available to any Excel workbook

 

[Gord Dibben]

Not so silly due to the complexity of macro storage.

Macros can live in workbooks, add-ins or perhaps in your Personal.xls

Try Tools>Macro>Macros.

Does the macro name appear in the list?

If so, hit the "Edit" button and copy the macro then paste it into the body of
the email.

If it doesn't appear in the list it could be a Private Sub or lives in an
add-in.

In that case, hit ALT + F11 to open the Visual Basic Editor.

You will have to browse through the Projects and find the module with the macro.

There are several ways to export......copy/paste the macro.

Export the entire module as a *.bas file which you can attach to an email.

The receiver would have to import that *.bas file into a workbook.

Too many ways to do this..........the above is just a couple.


Gord Dibben MS Excel MVP

Silly question, but where are Macros stored? Are they stored just in
the worksheet, or are they stored locally on the machine?

Thanks!

Gord Dibben MS Excel MVP

 

[Gord Dibben]

Ignore the part about emailing and exporting.

They are residue left from another question, but the rest should help.


Gord