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.