Forum home » Delegate support and help forum » Microsoft Excel Training and help » visual+basic+for+excel+courses+london - Spell check
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
visual+basic+for+excel+courses+london - Spell check
Resolved · Low Priority · Version Standard
Reply Wed 10 Oct 2007, 16:23Delegate Jason said...
Jason has attended:
Excel Advanced course
Spell check
Is it possible to create a macro/function that would pop up to remind you to spell check your excel file when closing the file.
For upcoming training course dates see: Pricing & availability
RE: 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
|
|