If I record a macro, where I
enter text to a drawing toolbar textbox
click a cell outside of the textbox
click ToolsSpelling
then the only useful code seems to be
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _
IgnoreUppercase:=False _
, AlwaysSuggest:=True, SpellLang:=2057
1. How can I use this so that when user leaves the textbox,
CheckSpelling automatically runs?
2. When I recorded the macro, CheckSpelling checked my
deliberate errors in the new text. It then asked If I wished
to check the entire sheet. Can I disable this feature with
code, please?
Regards.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004