Hi; I created a macro and userforms on an excel spreadsheet. I want to
copy everything (userforms, code, macros) to a new spreadhseet. How
can I do it?

I want to move all the code and macro's (I do not need any data in the
cells copied) to a new spreadsheet that contains the good data. The
current spreadhseet is going to be deleted. This is a one time process.

Oh, and please do not mentioned to "Try looking at Chip Pearson's page
on working with code in the VBE http://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.

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.

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.

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.