visual+basic+for+excel+courses+london - Spell check

Jason

Yes you can. But instead of reminding the person to do a spell check you could do it automatically.

To do this:

1. Open the relevant workbook
2. Open the Tools menu, Select Macro / Macros
3. On the Macro dialog box Click Edit
4. The Visual Basic Editor appears


In the Visual Basic Editor

1. Double click ThisWorkbook in the Project section

2. Enter the following code in the code area:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Cells.CheckSpelling SpellLang:=2057

End Sub

This runs the spellcheck (in English hence the 2057) before the workbook closes.

Hope this helps

Carlos