Is it possible to create a UserForm without a title bar?
No. The closest you can get is to make the dialog box’s caption blank by setting the Caption property to an empty string. I recorded some VBA code to print to a file. However, there seems to be no way to supply the filename in my code. No matter what I try, I keep getting the prompt to supply a filename. This was a common problem that was corrected in Excel 2000. In Excel 2000, you can provide a PrToFileName argument for the PrintOut method.
