Hi again
I'm still playing with a form for users. So far I didn have the form making the workbooks invisible to the user once it is opened, however there is not a minimize button on the form, and it isn't on the tool bar.
Is there any way I can stop the user from uising the workbooks, but still let the form put values into the workbooks, and how can I make the screen not get messy with lots of information.
Currently, the user opens a workbook that runs the form. The form then opens another workbook (as defined by the user). Then the form puts data into the new sheet that they have opened. Upon closure of the form, all the workbooks close (unfortunately all other workbooks close too!).
This is a bit of a messy question I know, but any help advice would be great!
Thanks