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.
|