Hello,

Does anyone know of a quick way to hide the sheet that the form is
submitting info to? I have experimented with worksheets.visible = true
but then i would need at least one sheet that is visible. my book
contains only one sheet and my form is referring to cells via
activecell.value = (fieldname) to submit the data upon clicking the
button but if i made another blank sheet so i could hide the proper one
i would have to change my input coding. (or would I?)

i also tried with making the form massive but you can still drag it out
of the way and also i would have to cater for differant screen
resolutions.

I'm not really good with vba macros (I'm really learning as i go along)
and it has took a good two days solid of experimenting to arrive where
i am now (which should take a competent programmer about an hour!) so
does anyone know of a real simple solution that im too simple to know
about?!