View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default HELP: Application.Visible issue - only hide workbook that has user

to hide ONLY the workbook that runs the userform , use

Windows(ThisWorkbook.Name).Visible = False

"sam" wrote:

Hi All,

I have a very critical issue with launching userform created in excel.

I have a like of code that says

Application.visible = false

I want to hide the workbook that has the userform only. But it hides all the
other opened workbooks too.. Is there a way to overcome this? There have been
users who had not saved their workbooks and launched the form and all their
excel files were gone.. How can I resolve this?

Thanks in advance