ExcelBanter - can I use spell check on a protected spredsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - can I use spell check on a protected spredsheet (https://www.excelbanter.com/excel-discussion-misc-queries/150011-can-i-use-spell-check-protected-spredsheet.html)

Mark

can I use spell check on a protected spredsheet

--
Mark

Gord Dibben

can I use spell check on a protected spredsheet

With a macro you can.

Sub Spell_Check()
ActiveSheet.Unprotect Password:="justme"
Cells.CheckSpelling SpellLang:=1033
ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True
End Sub

Gord Dibben MS Excel MVP

On Thu, 12 Jul 2007 15:02:06 -0700, Mark wrote:

All times are GMT +1. The time now is 02:52 AM.