Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You must unprotect the sheet, spellcheck then re-protect the sheet.
Sub Spell_Check() ActiveSheet.Unprotect Password:="justme" Cells.CheckSpelling SpellLang:=1033 ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _ Contents:=True, Scenarios:=True End Sub Note: was written using xl2003 so you may have to change the 1033 to accomodate xl2000. Never having used xl2000 I'm am not sure about that. Gord Dibben MS Excel MVP On Tue, 3 Oct 2006 08:51:01 -0700, MarkB wrote: I have a lot of forms made using excel 2000. The sheets are protected but cells that can be filled in are not locked. I have just noticed that the spell check is disabled whilst the sheet is locked. Has anyone come across this? and is there a fix/workaround? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spell Check cells in Protected Worksheet? | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Find & Replace within Unlocked Cells in a Protected Worksheet | Excel Discussion (Misc queries) | |||
move between unlocked cells on protected sheet | Excel Discussion (Misc queries) | |||
spell check protected document | Excel Discussion (Misc queries) |