Thread: macro I shared isn't available in any other workbooks?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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.


Reply With QuoteReply With Quote