Spell check
Can you perform spell check on a protected sheet in excel? If not is there a
macro or program that will do spell check while the sheet is protected? |
Spell check
Brent
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 not sure about that. Gord Dibben MS Excel MVP On Tue, 5 Dec 2006 13:04:01 -0800, Brent wrote: Can you perform spell check on a protected sheet in excel? If not is there a macro or program that will do spell check while the sheet is protected? Gord Dibben MS Excel MVP |
All times are GMT +1. The time now is 01:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com