The information in this article applies to:
- Microsoft Excel for Windows, versions 5.0, 5.0c
- Microsoft Excel for the Macintosh, version 5.0, 5.0a
- Microsoft Excel for the Power Macintosh, versions 5.0, 5.0a
- Microsoft Excel for Windows 95, versions 7.0, 7.0a
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
SUMMARY
In Microsoft Excel, you can check spelling for just the objects on a
worksheet. You can do this manually or with Microsoft Visual Basic for
Applications code.
MORE INFORMATION
To Check Spelling Manually
- Select the objects. To do this, select the first object, and then hold
down the SHIFT key and click each additional object.
- Click the Spelling button, or click Spelling on the Tools menu.
To Use a Macro to Check Spelling
- In a new module sheet, type the following code:
Sub Check_Object_Spelling()
ActiveSheet.DrawingObjects.CheckSpelling
End Sub
- Select the sheet that contains the objects for which you want to check
spelling.
- On the Tools menu, click Macro. Select the Check_Object_Spelling macro,
and then click Run.
Microsoft provides programming examples for illustration only, without
warranty either expressed or implied, including, but not limited to, the
implied warranties of merchantability and/or fitness for a particular
purpose. This article assumes that you are familiar with the programming
language being demonstrated and the tools used to create and debug
procedures. Microsoft support engineers can help explain the functionality
of a particular procedure, but they will not modify these examples to
provide added functionality or construct procedures to meet your specific
needs. If you have limited programming experience, you may want to contact
the Microsoft fee-based consulting line at (800) 936-5200. For more
information about the support options available from Microsoft, please see
the following page on the World Wide Web:
http://www.microsoft.com/support/supportnet/refguide/default.asp
For more information about using the spelling tool in Microsoft Excel for
Windows 95 version 7.0, click Answer Wizard on the Help menu, and type:
Check spelling
|