Thread: Macro question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Macro question

Macros live in workbooks.

So all you have to do is share the workbook with the macro with the other user.

If you recorded the macro in a workbook named personal.xls (or .xla), then have
that user rename it before they load it (just file|open).

If that user already has a personal.xl* file, then excel will have trouble--only
one workbook open at a time with the same name.

Melissa wrote:

I have recorded a macro (through Excel, not VBA) that I would like to
duplicate/share with another user. We are using Excel 2003 - any way to do
this besides re-creating the macro on the other machine?

Thanks.....


--

Dave Peterson