Copyright Symbol
 

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

Copyright Symbol
 

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

Copyright 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

Copyright Symbol
 

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

Copyright Symbol
 

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

Copyright Symbol
 

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

Copyright Symbol
 

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

Copyright Symbol
 

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

Copyright Symbol
 

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

Copyright Symbol
 

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

Copyright Symbol
 

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