View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bhiravi Bhiravi is offline
external usenet poster
 
Posts: 8
Default how to insert VB into a spreadsheet

I have a form into which users have to input a Y or N value. However, when
the user hits N, the form auto completes to add a value in the form that
begins with N. ALl i need is for it to stop at the N the user inputs. I
understand I have to input some sort of VB code to take effect at startup -
to prevent autocomplete, so that I dont have to physically go to every system
and disable autocomplete. How do I go about doing this?