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