Its regarding Hiding / Making the specific excel file invisible or hidden

Question

I have used the following VBA code :

'Workbooks("Budget.xlsm").Windows(1).Visible = False

'Windows("Budget.xlsm").Visible = False

Application.Visible = False

The problem with the above code is that it makes all the opened excel file invisible and not the one I required.

Also neither I can work nor I can open any other excel file using those commands.

Could you please help me out on this.

Answer 1

Hi

If you use this > 'Workbooks("Budget.xlsm").Sheets(1).Visible = False

That will hide only Sheet 1

Take note that you can go in the menu and unhide that sheet.

---

Cimjet

Answer 2

I am now using this

Application.Visible = False

What I need is...when I open up the required excel file a userform is displayed and my required excel file should be invisible.

The problem with the above code is that it makes all the opened excel file invisible and not the one I required.

Also neither I can work nor I can open any other excel file using that command.

Could you please help me out on this.

Answer 3

I'm not sure I understand, why can't you use the code I gave you and change the "Sheet1" for the name of the sheet you want to hide.                                        'Workbooks("Budget.xlsm").Sheets(1).Visible = False

---

Cimjet

Answer 4

Hi Cimjet,

Thanks for your reply... however I want the required excel file/workbook to be invisble / hidden and not just the sheet.

I hope I am clear this time.

Again, the main problem with the code(Application.Visible = False) is that it makes all the opened excel file invisible and not the one I required.

Also neither I can work nor I can open any other excel file using that command.

Could you please help me out on this.

Answer 5

I'm using Excel 2003 and not sure if newer version work the same way but I place this script in "ThisWorkbook" Module

Private Sub Workbook_Open()
UserForm1.Show
Workbooks("Userform.xls").Windows(1).Visible = False
End Sub

 The Workbook itself is open but all ths sheets are hidden, just the Userform is visible plus I can open a new workbook and it's not hidden.

I believe you can't hide fully the workbook and have the Userform visible but I could be wrong.

See if anyone else can shed some light.

---

Cimjet

Answer 6

Hi Cimjet,

Thanks... I am using Excel 2013 version

however I guess the code should be

Private Sub Workbook_Open()

Workbooks("Userform.xls").Windows(1).Visible = False  /*workbook command first

UserForm1.Show    /* Userform line 2nd
End Sub

Besides, the above code doesn't allow me to open another excel file also it doesn't allow me to work on the other excel file while my userform is open.

Do you know why?

Thanks

Answer 7

In the Userform properties,"Show Modal" should be False.

---

Cimjet

Answer 8

I will try this and will let you know...thanks a lot

Answer 9

Hi Cimjet,

The code works...thanks for that...

The new issue is ...when i move ahead with my userform say from userform1 to userform2....then my excel file gets visible (Is there a way to hide the required file till the time I am working on userform)

Thanks again

Answer 10

Re:  Workbook visibility

There is an option not mentioned so far ...

   Workbooks("Budget.xlsm").IsAddin =True    ' hides workbook
   Workbooks("Budget.xlsm").IsAddin = False  ' shows workbook

'---

Jim Cone
Portland, Oregon USA
https://goo.gl/IUQUN2 (Dropbox)

(free & commercial excel add-ins & workbooks)

Answer 11

Keep in mind, I don't know your application and I could be on the wrong track.

I made a sample file at the link below, it was made fast, just to see and I can't see your problem.

The workbook as two userform, you can open a new workbook, close the first userform that will open the second userform, work on the second workbook,close the second userform, and I'm out of idea. It works for me. Have a look at the sample file.

http://dropcanvas.com/oy4gw

Have a look at Jim Cone's post also

P.S. I'm often out and not sure when I'm back.

---

Cimjet

Answer 12

Hi Jim,

I tried using your code...there is a new problem...My application works like this..    I ask the user the put in the data using userform which is then inserted to the same excel file (Budget.xlsm).

Now if I use Workbooks("Budget.xlsm").IsAddin =True    ' hides workbook

this code it made the file hidden but my code then does not recognize the file

Dim File As String
File = "Budget.xlsm"

Windows(File).Activate  /' this is the place where i get the error

---

Regards, Hitesh

Answer 13

Re: trying to activate a hidden workbook (Addin)

A hidden workook can never be active and does not have a window to activate.

If you want to do something to/with a hidden workbook then reference the workbook and the approriate sheet...
   Workbooks("Budget.xlsm").Worksheets("Sludge").Range("B4").Value = "Mud"
The above works whether the workbook is hidden or visible.

If you want to "see" the workbook then set the IsAddin property to False.
'---
Jim Cone

Answer 14

Hi Cimjet,

The link does not seem to work

---

Regards, Hitesh

Answer 15

Hi Cimjet,

I have used your code

Workbooks("Budget.xlsm").Windows(1).Visible = False

for my excel file....But the problem now is that

My values for combo box are in the Budget.xlsm file and since the

Workbooks("Budget.xlsm").Windows(1).Visible = False

is now invisible ...the combo box have no values in it.

Could you please help me with this

---

Regards, Hitesh

Answer 16

Hi Jim,

I am now using the code given by Cimjet

Workbooks("Budget.xlsm").Windows(1).Visible = False

for my excel file....But the problem now is that

My values for combo box are in the Budget.xlsm file and since the

Workbooks("Budget.xlsm").Windows(1).Visible = False

is now invisible ...the combo box have no values in it.

Could you please help me with this

---

Regards, Hitesh

Answer 17

Hi Cimjet,

I am now using the your code

Workbooks("Budget.xlsm").Windows(1).Visible = False

for my excel file....But the problem now is that

My values for combo box are in the Budget.xlsm file and since the

Workbooks("Budget.xlsm").Windows(1).Visible = False

is now invisible ...the combo box have no values in it.... Also I have some List boxes in my userforms which are linked to some range in the excel file even they are blank

Could you please help me with this

---

Regards, Hitesh

Answer 18

Hi Jim,

I am now using the code given by Cimjet

Workbooks("Budget.xlsm").Windows(1).Visible = False

for my excel file....But the problem now is that

My values for combo box are in the Budget.xlsm file and since the

Workbooks("Budget.xlsm").Windows(1).Visible = False

is now invisible ...the combo box have no values in it.... Also I have some List boxes in my userforms which are linked to some range in the excel file even they are blank

Could you please help me with this

---

Regards, Hitesh

Answer 19

Hi ExcelUser2507,

Since the origal issue was resoved, I closed this thread temporarily. And to get more effective response, I also suggest that you split different issues into mutiple threads.

Regards & Fei

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.