I am creating a UserForm in VBA for use with an Excel workbook. I want the form to come up when the workbook opens, and remain on the screen the entire time the workbook is open. I have modified the workbook Open method to show the form, and I have set the ShowModal property of the form to FALSE to make the form modeless.

Problem: the form has a Windows Close button in its top right corner, so the user can close the form at any time. Is there someway to remove that button.

Secondary problem: the form has a command button. I can't see any way to format the text in the caption of the command button. For example, I would like to user a different font size, and make it bold. Is there any way to do that?

Thanks for your help.

Jim