macro I shared isn't available in any other workbooks?
 

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.

macro I shared isn't available in any other workbooks?
 

Where did you paste it? It should go in a standard code module
(insert from the VBA Insert menu), not the ThisWorkbook module or
a sheet code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"teh_chucksta" wrote in
message
...
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.

macro I shared isn't available in any other workbooks?
 

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.

macro I shared isn't available in any other workbooks?
 

Thanks Chip. I appreciate the help. I learned that I need to establish a
personal macro file for the people who will receive me macro, then add a new
module, then copy and paste the vb code into it.

Charlie

"Chip Pearson" wrote:

Where did you paste it? It should go in a standard code module
(insert from the VBA Insert menu), not the ThisWorkbook module or
a sheet code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"teh_chucksta" wrote in
message
...
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.

macro I shared isn't available in any other workbooks?
 

Thanks Tom,

You gave told me exactly what I needed to know. Macro works perfectly on
other users' workbooks.

Charlie

"Tom Ogilvy" wrote:

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.