View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
anon1m0us anon1m0us is offline
external usenet poster
 
Posts: 10
Default Copy Macro and Forms/code

I copied the forms and module over. But it still does not work. When i
click on cell A2, a form is supposed to pop up. It is not happening.
Susan wrote:
all you have to do is:

1. open the workbook that contains all the macros & userforms.
2. open a new workbook
3. open the VBA editor - you will see BOTH workbooks there
4. select & drag each module & userform from the old workbook to the
new workbook (will copy).
5. highlight, copy, & paste any worksheet or workbook macros that
aren't in a module.

:)
susan


On Apr 19, 10:44 am, anon1m0us wrote:
Oh, and please do not mentioned to "Try looking at Chip Pearson's page
on working with code in the VBEhttp://www.cpearson.com/excel/vbe.htm
"

I looked there and no clue what it is talking about. I need to copy
everything in the VBAProject. It can be manually.