0

I have a workbook with userform. I want to hide the workbook whenever I open the file and shows only userform. I need to hide only one workbook and show all other workbook and if I click on userform it should run from the workbook where the code is written. I used the following commands but it hides all the other workbooks.

application.visible= true

ActiveWindow.Visible = False
Community
  • 1
  • 1
adnan nazir
  • 1
  • 3
    Possible duplicate of [Hiding active workbook programmatically in Excel](http://stackoverflow.com/questions/11354456/hiding-active-workbook-programmatically-in-excel) – M-- Apr 27 '17 at 19:48

1 Answers1

0

This might help:

Windows("MyWorkbook").Visible = False
  • i did this but it still shows the excel window.i want to hide the window completely and shows when other workbook opens. secondly if i open other work and clik on my userform it shows an error i-e subscript out of range. how to fix it? – adnan nazir Apr 27 '17 at 20:08