Right-click on the Excel logo left of "File" on menu or on left side of title
bar if window is not maximized and select "View Code"

This opens the Thisworkbook module.

Copy/paste the two sets of code into that module.

Save and Close workbook..........reopen.


Gord Dibben MS Excel MVP

On Thu, 21 Dec 2006 11:42:00 -0800, Bhiravi
wrote:

Thanks a lot for your response, I have a wuestion for you regarding using the
VB, how would I enter that into the spreadheet?

"stumac" wrote:

Hi Bhiravi, you can go into Tools, Options, Edit, and deselect the enable
autocomplete. This would need to be done on all machines where the form is
used. Alternatively you could put some vb in:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.EnableAutoComplete = True
End Sub

Private Sub Workbook_Open()
Application.EnableAutoComplete = False
End Sub

Just to check when you say form are you referring to a formatted worksheet
that looks like a form? If so you can set up the data validation to only
allow the values Y & and N, then even though it will suggest an auto complete
it wont allow the user to continue with that value.

Hope this helps

Stu


"Bhiravi" wrote:

I have a form set up to accept Y or N values input by the user. However, when
the user puts in an N value, the spreadsheet auto enters a value beginning
with N that was entered into another cell. Ie. it is auto inputting from
memory I'm assuming? How do I erase this, so that when the user puts in the
input, Excel does not assume what the user is typing?