Rich,

Thanks for your response. The worksheets will always be protected, and I am
looking for a code that would enable the Spelling option under Tools while
the worksheets are password-protected.

I do not understand one thing is there is a code "EnableFilter", and why
there is no code for "EnableSpelling".

Thanks.

"Rich Locus" wrote:

Hello:

If you have your worksheet protected, then you could put two buttons on the
worksheet: one to unprotect, and one to protect. This is useful if you are
not concerned with security and just want to keep the user from altering
items by mistake.

Here are the subroutines... use your own passwords. I used this technique
for a similar purpose with the understanding that the user would not attempt
anything unusual while in an unprotected state.

Sub Btn_UnProtect()
'
Sheets("POMIS").Select
ActiveSheet.Unprotect Password:="rob"

End Sub

Sub Btn_Protect()
'
Sheets("POMIS").Select
ActiveSheet.Protect Password:="rob", DrawingObjects:=False,
Contents:=True, Scenarios:= _
False, AllowSorting:=True, AllowFiltering:=True

End Sub

--
Rich Locus
Logicwurks, LLC


"Accesshelp" wrote:

Hello all,

I have an Excel file that password-protects the worksheets and workbook.
Due to the password-protecting the worksheets, the Spelling option under
Tools menu is not available.

Could someone help me with a code to have the Spelling option enabled while
the worksheets are password-protected?

Thanks.