Protected Functions

[Tyler Durden]

I am designing a file that includes multiple forms for people to fill out. Each tab is a seperate form that is protected to allow the user to tab between necessary, unlocked fields. Is there a way you can apply spell check to an unlocked, protected field? Or by protecting the sheet does it not allow you to use the spell checker? Secondly, there are pulldown lists I have created under "Validation". Is there a way to make those lists AutoComplete when a letter or series of letters is typed in the cell?

Thanks for any help!

 

[Brian from Maui]

On 2002-04-24 12:42, Tyler Durden wrote:
I am designing a file that includes multiple forms for people to fill out. Each tab is a seperate form that is protected to allow the user to tab between necessary, unlocked fields. Is there a way you can apply spell check to an unlocked, protected field? Or by protecting the sheet does it not allow you to use the spell checker? Secondly, there are pulldown lists I have created under "Validation". Is there a way to make those lists AutoComplete when a letter or series of letters is typed in the cell?

Thanks for any help!

Tyler,

For the second questions, go to Tools/Auto Correct and compile your list