View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Frank is offline
external usenet poster
 
Posts: 170
Default Application Visible

Hi,

I have created a worksheet start with a Userform and with the command
Private Sub UserForm_Initialize()
Application.Visible = False
end sub

only the userform is visible for users and not the worksheet. This works
fine. Only thing is that with this option all my open worksheets are hidden.
Only by closing this worksheet all my other opened excelsheets are visible
again. IS there a way to only hide the worksheet i want to hide and to be
able to work with others at the same time.

Thanks in advance!

Kind regards,

Frank