How does a user spell check protected document in Excel?

[Mary]

I created an Excel template that is protected. The users are able to enter
data in the unlocked sells but can not spell check their work.

Is there a way for a user to check spelling without taking off the protection?

Mary

 

[Mike H]

Mary,

you need a macro

right click your sheet tab, view code and paste this in. Attach it to a
button on your sheet

Sub SpellIt()
ActiveSheet.Unprotect Password:="MyPass"
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC"
ActiveSheet.Protect Password:="MyPass"
End Sub

Mike

 

[Gord Dibben]

Using a macro is the only work around that I know of.

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

Unprotects the sheet, does the spellcheck then reprotects the sheet.

"justme" can be changed to your password.

Note: code is for versions 2002 and 2003.

The 1033 may be different in 2007


Gord Dibben MS Excel MVP

 

[Mary]

Mike,

When I click the button I receive the following error message:
"The macros in this project are disabled. Please refer to the online help or
documentation of the host applicatoin to determine how to enable macros."

I'm using Excel 2007 and have selected Enable all macros (although not
recommended) and have checked the box to trust acces to the VBA prject object
model.

Any other recommendations will be appreciated.

Thanks,
Mary

 

[Mary]

Gord,

When I click the button I receive the following error message:
"The macros in this project are disabled. Please refer to the online help or
documentation of the host applicatoin to determine how to enable macros."

I'm using Excel 2007 and have selected Enable all macros (although not
recommended) and have checked the box to trust acces to the VBA prject object
model.

Any other recommendations will be appreciated.

Thanks,
Mary

 

[Gord Dibben]

I don't use 2007 so can't help you there.

All a mystery>g?


Gord

 

[Mary]

Thanks just the same - thanks for trying to help

I don't use 2007 so can't help you there.

All a mystery>g?


Gord