Thread: Copying code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
wal50 wal50 is offline
external usenet poster
 
Posts: 39
Default Copying code

New to VBA so ...
I have copied some of the great code from CPearson.com. If I open a new
workbook and add the code to a new module. it works for that workbook (only).
What I want to do is add it to personal.xls so it works in all workbooks. I
can't get this to happen. I add a new module to personal.xls, copy the code
and it doesn't work. Other macros that I have in Personal.xls work fine in
all books.
Any ideas?
Thanks.
WAL50