Protected Functions

Tyler Durden · Apr 24th, 2002, 01:42 PM

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 · Apr 24th, 2002, 01:55 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 01:42 PM	#1
Tyler Durden New Member Join Date: Apr 2002 Location: USA Posts: 17	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!