You can't change protection of a worksheet in a shared workbook.

DaveyC4S wrote:

I have successfully used the code from a previous discussion post to activate
the spell check function in a protected worksheet.

However when I share the workbook and run the macro the error: "400"
appears. When I go to the Help option the help screen is blank.

Does anyone have any idea how I can use the spell check in a protected
worksheet within a shared workbook?

The code used from the previous discussion is shown below.

Many thanks
Dave

Cats

Requires VBA to unprotect the sheet, do the spellcheck then reprotect the
sheet.

Similar to.......

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 Excel MVP

On Wed, 16 Feb 2005 11:05:06 -0800, "Cats"
wrote:

Office 2003 - Excel
I am trying to make it possible for personnel to spell check information
they insert, in a unlocked cell in a password protected worksheet. I have
tried everything I can find in all HELP areas, but cannot find anything

--

Dave Peterson