How does a user spell check protected document in Excel?

M

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
 
M

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
 
G

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
 
M

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spell Check on Excel document 2
Spell Check with protected sheets 3
Enabling Spell Check in Protected Worksheet 2
Spell check and protection 1
Spell Check Protect Reprotect with same settings 1
spell check protected document 1
spell check in an Excel protected sheet 1
Spell check a protected spreadsheet 2

Top