Heyup all,
First of all thanks to everyone who helped me out with the =sumproduct queries, everything with my MI pack is working great!
Im a little stumped with a bit of VBA coding and wondering if anyone can help,
Ive created a submission form that people will open in readonly......I'm trying to set it up so that when they open this form, "mainly for visial purposes" I want to set the window width and height to fit around the form and if possible, eliminate all the options from the top of the window leaving only the file - edit etc options. Essentially giving the impression that the form is a standalone "program" for better choice of words.
I've seen it done, any help???
cheers
Paul
First of all thanks to everyone who helped me out with the =sumproduct queries, everything with my MI pack is working great!
Im a little stumped with a bit of VBA coding and wondering if anyone can help,
Ive created a submission form that people will open in readonly......I'm trying to set it up so that when they open this form, "mainly for visial purposes" I want to set the window width and height to fit around the form and if possible, eliminate all the options from the top of the window leaving only the file - edit etc options. Essentially giving the impression that the form is a standalone "program" for better choice of words.
I've seen it done, any help???
cheers
Paul