Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |