View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Copy Macro and Forms/code

perhaps the code from the OLD workbook referred to certain sheet names
that are different in the new workbook???

look for anything that says something like

..worksheet("xxxx")

and make sure the xx's are the names of your CURRENT workbook
worksheets.

hth
susan


On Apr 19, 11:32 am, anon1m0us wrote:
Maybe the Macro is not running?



anon1m0us wrote:
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.- Hide quoted text -


- Show quoted text -