ExcelBanter - Carrying formatting automatically to new W/S

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Carrying formatting automatically to new W/S (https://www.excelbanter.com/excel-worksheet-functions/43830-carrying-formatting-automatically-new-w-s.html)

Carrying formatting automatically to new W/S

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"
<html
When I copy a workbook I want to be able to maintain the formatting and
layout.
<pWhenever I have done this, the new worksheet always loses the formatting
from the original.  For example the original has some <bemboldened</b
text, but on the copied sheet the emboldening has been lost.
<pJonah</html

Right click on the sheet tab(s),
Select "Move or Copy",
Click on "Create a Copy",
Expand the "To Book" box and click on "New Book",
Then <OK.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jonah" wrote in message
...
When I copy a workbook I want to be able to maintain the formatting and
layout.
Whenever I have done this, the new worksheet always loses the formatting
from the original. For example the original has some emboldened text, but
on the copied sheet the emboldening has been lost.

Jonah

Sorry about this, but it is not a new W/B but a new worksheet I needed. I also
tried what you said and I still get no formatting carried over.

J

Ragdyer wrote:

Right click on the sheet tab(s),
Select "Move or Copy",
Click on "Create a Copy",
Expand the "To Book" box and click on "New Book",
Then <OK.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jonah" wrote in message
...
When I copy a workbook I want to be able to maintain the formatting and
layout.
Whenever I have done this, the new worksheet always loses the formatting
from the original. For example the original has some emboldened text, but
on the copied sheet the emboldening has been lost.

Jonah

Might there be some underlying code in the sheet?

This procedure copies a sheet *exactly*, whether the original is protected
or not, whether it's saved or not ... it just works!

Describe exactly what you did, and where you did it.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jonah" wrote in message
...
Sorry about this, but it is not a new W/B but a new worksheet I needed. I
also
tried what you said and I still get no formatting carried over.

J

Ragdyer wrote:

Right click on the sheet tab(s),
Select "Move or Copy",
Click on "Create a Copy",
Expand the "To Book" box and click on "New Book",
Then <OK.

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Jonah" wrote in message
...
When I copy a workbook I want to be able to maintain the formatting
and
layout.
Whenever I have done this, the new worksheet always loses the
formatting
from the original. For example the original has some emboldened text,
but
on the copied sheet the emboldening has been lost.

Jonah

Underlying code? Where do I look?

Jonah
-------------

Ragdyer wrote:

Might there be some underlying code in the sheet?

This procedure copies a sheet *exactly*, whether the original is protected
or not, whether it's saved or not ... it just works!

Describe exactly what you did, and where you did it.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jonah" wrote in message
...
Sorry about this, but it is not a new W/B but a new worksheet I needed. I
also
tried what you said and I still get no formatting carried over.

J

Ragdyer wrote:

Right click on the sheet tab(s),
Select "Move or Copy",
Click on "Create a Copy",
Expand the "To Book" box and click on "New Book",
Then <OK.

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Jonah" wrote in message
...
When I copy a workbook I want to be able to maintain the formatting
and
layout.
Whenever I have done this, the new worksheet always loses the
formatting
from the original. For example the original has some emboldened text,
but
on the copied sheet the emboldening has been lost.

Jonah