software

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

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

Just go to CHARMAP (Start-gt;Run-gt;type charmap click OK
Select the copyright symbol
click copy
go to Excel
View-gt;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 gt; AutoCorrect Options, the AutoCorrect tab.

quot;Karenquot; wrote:

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

That doesn't seem to work in the header

SVC wrote:
gt; It should be set up as an AutoCorrect option: (c) should convert to
gt; your copyright symbol. Check Tools gt; AutoCorrect Options, the
gt; AutoCorrect tab.
gt;
gt; quot;Karenquot; wrote:
gt;
gt;gt; Is there a way to create a copyright symbol into the header or
gt;gt; footer of Excel 2003?
gt;gt; Thank you

The easiest way is to hold ALT and type 0169.

Check out this page for more symbols:

www.forlang.wsu.edu/help/keyboards.asp
quot;Karenquot; wrote:

gt; Is there a way to create a copyright symbol into the header or footer of
gt; Excel 2003?
gt; 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(quot;Sheet1quot;).Range(quot;z1quot;)
End Sub

Hope that helps,,
Jim Mayquot;Paul Lautmanquot; gt; wrote in message
...
gt; That doesn't seem to work in the header
gt;
gt; SVC wrote:
gt;gt; It should be set up as an AutoCorrect option: (c) should convert to
gt;gt; your copyright symbol. Check Tools gt; AutoCorrect Options, the
gt;gt; AutoCorrect tab.
gt;gt;
gt;gt; quot;Karenquot; wrote:
gt;gt;
gt;gt;gt; Is there a way to create a copyright symbol into the header or
gt;gt;gt; footer of Excel 2003?
gt;gt;gt; Thank you
gt;
gt;
gt;
No you don't. My first post explaining how to do it with charmap works fine.

Jim May wrote:
gt; You have to use VBA;
gt; In a cell (somewhere, say Z1), do (from the Menu, Insert
gt; Symbol, Click (once you find it) the Circled C.. - Click on the
gt; Insert button.
gt; Now with Z1 = C (copyright sign)
gt;
gt; Go to VBE - This Workbook,
gt; Private Sub Workbook_BeforePrint(Cancel As Boolean)
gt; ActiveSheet.PageSetup.LeftHeader = Sheets(quot;Sheet1quot;).Range(quot;z1quot;)
gt; End Sub
gt;
gt; Hope that helps,,
gt; Jim May
gt;
gt;
gt; quot;Paul Lautmanquot; gt; wrote in message
gt; ...
gt;gt; That doesn't seem to work in the header
gt;gt;
gt;gt; SVC wrote:
gt;gt;gt; It should be set up as an AutoCorrect option: (c) should convert to
gt;gt;gt; your copyright symbol. Check Tools gt; AutoCorrect Options, the
gt;gt;gt; AutoCorrect tab.
gt;gt;gt;
gt;gt;gt; quot;Karenquot; wrote:
gt;gt;gt;
gt;gt;gt;gt; Is there a way to create a copyright symbol into the header or
gt;gt;gt;gt; footer of Excel 2003?
gt;gt;gt;gt; Thank you

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

quot;Hubitron2000quot; wrote:

gt; The easiest way is to hold ALT and type 0169.
gt;
gt; Check out this page for more symbols:
gt;
gt; www.forlang.wsu.edu/help/keyboards.asp
gt;
gt;
gt;
gt; quot;Karenquot; wrote:
gt;
gt; gt; Is there a way to create a copyright symbol into the header or footer of
gt; gt; Excel 2003?
gt; gt; Thank you


hi!

try this!

=CHAR(169)

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=524587the 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.

quot;Paul Lautmanquot; wrote:

gt; That doesn't seem to work in the header
gt;
gt; SVC wrote:
gt; gt; It should be set up as an AutoCorrect option: (c) should convert to
gt; gt; your copyright symbol. Check Tools gt; AutoCorrect Options, the
gt; gt; AutoCorrect tab.
gt; gt;
gt; gt; quot;Karenquot; wrote:
gt; gt;
gt; gt;gt; Is there a way to create a copyright symbol into the header or
gt; gt;gt; footer of Excel 2003?
gt; gt;gt; Thank you
gt;
gt;
gt;
gt;