<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
code
{font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I was browsing tech republic’s tips at <a
href="http://blogs.techrepublic.com.com/msoffice/?p=201&tag=nl.e056">http://blogs.techrepublic.com.com/msoffice/?p=201&tag=nl.e056</a>
and came across this which may be of use for the online manual. </span></font><strong><b><i><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial;font-style:
italic'>Note:</span></font></i></b></strong><em><i><font size=2 face=Arial><span
style='font-size:9.5pt;font-family:Arial'> This tip applies to Excel 2002/2003.</span></font></i></em><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>From <st1:place
w:st="on"><st1:PlaceName w:st="on">Tech</st1:PlaceName> <st1:PlaceType w:st="on">Republic</st1:PlaceType></st1:place>
website:<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>It’s
quick and easy to create help messages using Excel’s 2002/2003’s
Data Validation feature, as long as your help message is 250 words or less. If
you need to write a help message that exceeds this limit, such as a mini-manual
with examples, you can create a text box that will appear when the user clicks
on a “help” button in the toolbar. Follow these steps:<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>1.
Right-click any toolbar and select Drawing.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>2. Click the
text box button and click and drag it in your worksheet to create a text box as
large as you need to enter your help text.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>3. Enter and
format your help text.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>4. Click
anywhere outside your textbox and press [Alt][F8].<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>5. In the
Macro Name box, enter <em><i><font face=Arial><span style='font-family:Arial'>ToggleHelpText</span></font></i></em>.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>6. Click
Create.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><code><font
size=3 face="Courier New"><span style='font-size:11.5pt'>7. </span></font></code><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>Enter the
following code at the prompt, all on one line:<br>
</span></font><code><font size=3 face="Courier New"><span style='font-size:
11.5pt'>ActiveSheet.TextBoxes.Visible =Not ActiveSheet.TextBoxes.Visible</span></font></code><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>8. Press
[Alt]Q.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>9. Go to
Tools | Customize.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>10. Under the
Categories list, scroll to and select Macros.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>11. Click and
drag the Custom Button to a toolbar.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>12.
Right-click the Custom Button and select Assign Macro.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>13. Click
ToggleHelpText and then click OK.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>14. Click
Close.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>By clicking
the Custom Button, users can get help when they need it.<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>Cheers…<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:9.0pt;margin-right:7.5pt;
margin-bottom:9.0pt;margin-left:7.5pt;line-height:15.6pt;background:white'><st1:PersonName
w:st="on"><font size=2 face=Arial><span style='font-size:9.5pt;font-family:
Arial'>Maree Duivenvoorden</span></font></st1:PersonName><br>
<st1:place w:st="on"><st1:PlaceName w:st="on"><font size=2 face=Arial><span
style='font-size:9.5pt;font-family:Arial'>Toorak</span></font></st1:PlaceName><font
size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'> <st1:PlaceType
w:st="on">College</st1:PlaceType></span></font></st1:place><br>
<font size=2 face=Arial><span style='font-size:9.5pt;font-family:Arial'>Old <st1:Street
w:st="on"><st1:address w:st="on">Mornington Road</st1:address></st1:Street>,<br>
<st1:place w:st="on"><st1:PlaceType w:st="on">Mount</st1:PlaceType> <st1:PlaceName
w:st="on">Eliza</st1:PlaceName></st1:place> 3930<br>
Phone 03 97887252<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>