98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » visual+basic+for+excel+courses+london - Spell check
visual+basic+for+excel+courses+london - Spell check
Resolved · Low Priority · Version Standard
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.
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
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. |
Excel tip:Use the SUBTOTAL function in ExcelYou can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this: |