Hide Workbook When User Form Opens

[wandan]

Hello,

I have a UserForm in my Excel 2003 workbook that opens automatically when the workbook opens. I would like for the users to only be able to see the form and not the workbook itself. Is there a way to hide the workbook and leave the form open?

Thanks.

 

[Gruuuu]

There must be at least one worksheet visible at all times...

However you CAN hide all the cells, which will only leave the "select all" area exposed.

 

[DaveInIowa]

Take a look at the Application.Visible property.

 

[SkipVought]

Application.visible=false

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}