Just open the workbook that contains the macro. It can then be manually
executed against any other open workbook depending on how you have written it
(your have written it to act on the Activesheet).

Each user has a personal.xls workbook if they have recorded a macro or
otherwise created one. (if you record a macro on her machine and she does
not have one, then it will create it if you designate it as the location for
the recorded macro). The only advantage of this workbook is that it is
marked as hidden and since it is located in the xlstart directory, it is
opened each time Excel is opened (manually).

So, if you open her excel and go to the VBE and find the personal.xls in the
projects, you can paste your macro here as well (to personalize it).

--
Regards,
Tom Ogilvy


"teh_chucksta" wrote:

I copied & pasted a VB macro into another's Visual Basic Editor to streamline
a process but the macro can't be found in any of her other workbooks. I think
it needs to be designated as a personalized macro but that option isn't
offered. How to proceed? Thanks.