MrExcel Publishing
Your One Stop for Excel Tips & Solutions

UserForms - "Zen" Maybe You Can Help


Posted by Randycas on July 10, 2001 5:35 AM

I have this hugh workbook which will be used to update our files in the office. What I would like to do is have the user see only the Userform and not the worksheets. I have started with the easiest worksheet and have painstakingly tried to write code (since I know nothing about VB). The form works but I still see the excel worksheet in the background. Is there anyway that I can hide it? I noticed that M Walker raised the same question on 3rd July. i would appreciate any help with this matter. Thanx


Posted by M Walker on July 10, 2001 6:37 AM

Hi,

I found that by using this code i can hide the workbook and show only the userform. If you right click on workbook in the project exploer and add it to the code the spreadsheet should minimize.

Private Sub Workbook_Open()
Application.WindowState = xlMinimized
Welcome.Show

End Sub

Please note that "Welcome" is the name of my first userform.

Goodluck

M Walker