Spell Checking in Protected Sheet

[Mike Tennor]

I have a worksheet intended for user input. Some of the
input will be text. The worksheet is protected so the
users do not change the protected values. However, when
the worksheet is protected the spell checking is disabled.
Does anyone know how to allow the spelling to be checked
in the unprotected cells?

Thanks,
Mike

 

[Mike Tennor]

Paul,

Thanks for your response. But can't the user look at the
macro and see the password?

Mike

 

[Paul B]

Not if you protect the VBA project with a password

 

[Mike Tennor]

Paul - Thanks - you're good - Mike

-----Original Message-----
here's how to do it,
To protect the VBA project press alt and F11 to open the VBA editor, in the
left hand window right click on your workbook name and select VBA project
properties, protection, check lock project for viewing and set a password.
Press Alt and Q to close this window and go back to your workbook and save
and close the file

--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **




.