| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protected spell check for Excel 97
See one response at your post in .misc
Jessica wrote: So this code works for Excel 2003: Sub Spell_Check() ActiveSheet.Unprotect Password:="justme" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub However when I was trying to get it to work for someone, they were using an older version of Excel (I believe it was 97), so how can I get the code to work to get the spell check to work under protection? I kept getting error messages such as: "Can't execute code in break mode" and "Compile error: named argument not found" and then it highlights this part of the code: SpellLang:=1033 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does a user spell check protected document in Excel? | Excel Discussion (Misc queries) | |||
| spell check on protected sheet | Excel Discussion (Misc queries) | |||
| How do I use the spell check on a protected sheet in Excel? | Excel Worksheet Functions | |||
| spell check for protected worksheet for Excel 97 | Excel Discussion (Misc queries) | |||
| spell check in an Excel protected sheet | Excel Discussion (Misc queries) | |||
![Dave Peterson[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
