Are you copying the complete worksheet to a new workbook--or are you copying
some of the cells (all??) and then pasting into an existing worksheet in a
different workbook?



Paul H wrote:

"Dave Peterson" wrote:

If you use a commandbutton from the control toolbox toolbar, then the code for
that commandbutton is located behind the sheet.

And if you do copy the entire sheet (like edit|move or copy sheet), the both the
button and the code will go with that sheet.

The sheet I'm copying the new worksheet too already has a couple macro in, could this be the problem?

Paul H wrote:

"Dave Peterson" wrote:

Maybe you can use a control from the Control Toolbox toolbar (like a
commandbutton???).

When you copy the entire sheet (not the cells), the code behind the sheet will
travel with that sheet.

Paul H wrote:

It is possisle to attach a macro to a single worksheet so I can easily copy
the worksheet w/macro to another workbook?

Paul

--

Dave Peterson

The command button won't work in this case as the worksheet is to be
inserted into files that others will use.
I do copy the entire sheet but the macro referance remains to the original
file.

Paul

--

Dave Peterson


--

Dave Peterson