Where are Macros stored?
 

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

Thanks!


--
smorgan
------------------------------------------------------------------------
smorgan's Profile: http://www.excelforum.com/member.php...o&userid=35829
View this thread: http://www.excelforum.com/showthread...hreadid=557329

Where are Macros stored?
 

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

"smorgan" wrote:


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

Thanks!


--
smorgan
------------------------------------------------------------------------
smorgan's Profile: http://www.excelforum.com/member.php...o&userid=35829
View this thread: http://www.excelforum.com/showthread...hreadid=557329

Where are Macros stored?
 

Not so silly due to the complexity of macro storage.

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

Try ToolsMacroMacros.

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

On Fri, 30 Jun 2006 09:15:02 -0500, smorgan
wrote:


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

Where are Macros stored?
 

Ignore the part about emailing and exporting.

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


Gord

On Fri, 30 Jun 2006 09:11:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Not so silly due to the complexity of macro storage.

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

Try ToolsMacroMacros.

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

On Fri, 30 Jun 2006 09:15:02 -0500, smorgan
wrote:


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