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

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

"Mary" wrote:

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,

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

"Mike H" wrote:

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

"Mary" wrote:

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

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


On Thu, 9 Oct 2008 11:24:15 -0700, Mary
wrote:

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

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" wrote:

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


On Thu, 9 Oct 2008 11:24:15 -0700, Mary
wrote:

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

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

All a mysteryg?


Gord

On Thu, 9 Oct 2008 14:11:01 -0700, Mary
wrote:

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" wrote:

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


On Thu, 9 Oct 2008 11:24:15 -0700, Mary
wrote:

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

Thanks just the same - thanks for trying to help

"Gord Dibben" wrote:

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

All a mysteryg?


Gord

On Thu, 9 Oct 2008 14:11:01 -0700, Mary
wrote:

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" wrote:

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


On Thu, 9 Oct 2008 11:24:15 -0700, Mary
wrote:

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