I have 5 sheets A,B,C,D,E in a work book X & each of B,C,D and E have links
to cells in sheet A.
I need a macro to copy workbook X to to a new workbook Y using the same
sheetnames as in X but for the new A,B,C,D & E sheets in Y to have all links
removed.

Hi Chris,

I wonder if you really need a macro to do this?
Save the workbook as a new filename.
Hold the Ctrl key down while you select each of the worksheets. Or select
the first worksheet and hold the Shift key while you select the last
worksheet. (Either method selects multiple worksheets).
Click on the rectangle where the column and row identifiers meet (top left
of worksheet) to select entire worksheet/s.
Copy - Paste Special - Values.

--
Regards,

OssieMac


"Chris Maddogz" wrote:

I have 5 sheets A,B,C,D,E in a work book X & each of B,C,D and E have links
to cells in sheet A.
I need a macro to copy workbook X to to a new workbook Y using the same
sheetnames as in X but for the new A,B,C,D & E sheets in Y to have all links
removed.

I realise I can do this manually but I need to automate it for the office
users so as to avoid any problems


"OssieMac" wrote:

Hi Chris,

I wonder if you really need a macro to do this?
Save the workbook as a new filename.
Hold the Ctrl key down while you select each of the worksheets. Or select
the first worksheet and hold the Shift key while you select the last
worksheet. (Either method selects multiple worksheets).
Click on the rectangle where the column and row identifiers meet (top left
of worksheet) to select entire worksheet/s.
Copy - Paste Special - Values.

--
Regards,

OssieMac


"Chris Maddogz" wrote:

I have 5 sheets A,B,C,D,E in a work book X & each of B,C,D and E have links
to cells in sheet A.
I need a macro to copy workbook X to to a new workbook Y using the same
sheetnames as in X but for the new A,B,C,D & E sheets in Y to have all links
removed.

OK Chris. What version of xl are you using?

--
Regards,

OssieMac

Using 2007 but macro will also run on previous version

"OssieMac" wrote:

OK Chris. What version of xl are you using?

--
Regards,

OssieMac