Is there a way to create a copyright symbol into the header or footer of
Excel 2003?
Thank you

Karen wrote:
Is there a way to create a copyright symbol into the header or footer
of Excel 2003?
Thank you

Just go to CHARMAP (Start-Run-type charmap click OK
Select the copyright symbol
click copy
go to Excel
View-Header and Footer...
Paste in the symbol

It should be set up as an AutoCorrect option: (c) should convert to your
copyright symbol. Check Tools AutoCorrect Options, the AutoCorrect tab.

"Karen" wrote:

Is there a way to create a copyright symbol into the header or footer of
Excel 2003?
Thank you

That doesn't seem to work in the header

SVC wrote:
It should be set up as an AutoCorrect option: (c) should convert to
your copyright symbol. Check Tools AutoCorrect Options, the
AutoCorrect tab.

"Karen" wrote:

Is there a way to create a copyright symbol into the header or
footer of Excel 2003?
Thank you

You have to use VBA;
In a cell (somewhere, say Z1), do (from the Menu, Insert
Symbol, Click (once you find it) the Circled C.. - Click on the Insert
button.
Now with Z1 = C (copyright sign)

Go to VBE - This Workbook,
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Sheets("Sheet1").Range("z1")
End Sub

Hope that helps,,
Jim May


"Paul Lautman" wrote in message
...
That doesn't seem to work in the header

SVC wrote:
It should be set up as an AutoCorrect option: (c) should convert to
your copyright symbol. Check Tools AutoCorrect Options, the
AutoCorrect tab.

"Karen" wrote:

Is there a way to create a copyright symbol into the header or
footer of Excel 2003?
Thank you

No you don't. My first post explaining how to do it with charmap works fine.

Jim May wrote:
You have to use VBA;
In a cell (somewhere, say Z1), do (from the Menu, Insert
Symbol, Click (once you find it) the Circled C.. - Click on the
Insert button.
Now with Z1 = C (copyright sign)

Go to VBE - This Workbook,
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Sheets("Sheet1").Range("z1")
End Sub

Hope that helps,,
Jim May


"Paul Lautman" wrote in message
...
That doesn't seem to work in the header

SVC wrote:
It should be set up as an AutoCorrect option: (c) should convert to
your copyright symbol. Check Tools AutoCorrect Options, the
AutoCorrect tab.

"Karen" wrote:

Is there a way to create a copyright symbol into the header or
footer of Excel 2003?
Thank you

the only way I could get it to work was to use the auto correct feature (
type in (c))in the actual worksheet then copy it and paste it into the header.

"Paul Lautman" wrote:

That doesn't seem to work in the header

SVC wrote:
It should be set up as an AutoCorrect option: (c) should convert to
your copyright symbol. Check Tools AutoCorrect Options, the
AutoCorrect tab.

"Karen" wrote:

Is there a way to create a copyright symbol into the header or
footer of Excel 2003?
Thank you

The easiest way is to hold ALT and type 0169.

Check out this page for more symbols:

http://www.forlang.wsu.edu/help/keyboards.asp

:)

"Karen" wrote:

Is there a way to create a copyright symbol into the header or footer of
Excel 2003?
Thank you

Thank you all for your input - The ALT keyboard symbols works great - Thanks
again!

"Hubitron2000" wrote:

The easiest way is to hold ALT and type 0169.

Check out this page for more symbols:

http://www.forlang.wsu.edu/help/keyboards.asp

:)

"Karen" wrote:

Is there a way to create a copyright symbol into the header or footer of
Excel 2003?
Thank you

hi!

try this!

=CHAR(169)

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=524587

Thank you this was very helpful and the easiest way.
--
M. Claire


"Hubitron2000" wrote:

The easiest way is to hold ALT and type 0169.

Check out this page for more symbols:

http://www.forlang.wsu.edu/help/keyboards.asp

:)

"Karen" wrote:

Is there a way to create a copyright symbol into the header or footer of
Excel 2003?
Thank you