Automatically Hide Workbook in Background and View only User Form 

the video is great, simple and clear. i can't wait to try it.

this video is what I've been looking for for so long

This was another great tutorial. You're the best

Thnk you for your teaching. I like it

You are simply Great ... Thanks a lot .. Would have been more helpful if you could show " How to save that data in a different excel workbook.

Thank you for this video lesson sir Dinesh. It helps a lot.

Thank you that was so helpful

Wonderful Mr. Takyar

This was very useful. Thanks!!

Nice simple explanation. Thank you.

awsome tuto man... good simplicity

Wow! Excellent..... With this simple tutorial I was able to create a Customer/Product and inventory data recording. But I still need help please. Thanks

So simple and well explained... kudos ir...

Thank you

Hello sir thank you for updating this video, it's very helpful, i wonder if there is a way to close only one workbook instead of closing all the workbooks ( application.visibile = false close all the excel files )

Appreciate your explanation. Can you also guide if there is any way to hide only the workbook which has this macros and not others.

Thank you Sir.

Dinesh, Helped me heaps recently with your video on ranking with a dummy rank solved a massive headache for me. I have a user form that is not a data entry point to input imformation into a sheet. I have a user form that has 12 Buttons on in. When you press the button it selects the Workbook associated with that button. I am watching this video so that the first workbook is hidden but from the user form i can access any of the other workbooks from the user form.

Thank u sir for sch a great video

Very good 👍. Keep it up

Excellent

Sir, another addition if you allow me. In bank recon also, assume that if there is outstanding items from the previous one.. In this case what shall I do?

Hello, Do we have ability to use excel to start or stop windows server services?

thank you very very very much because this program "work"

Dear sir, I would like to thank you a lot but what I asked for bank recon did not meet my requirement because suppose that two statements in different workbook and the narration of the bank will not be the same of company and we have debit and credit in two columns. so what debit here will be credit there. shall I combine in one workbook?

Hi, is it possible to close the excel application when pressing the close button, but on the excel that the userform is in not all the other excel files that you have open on your pc. Thanks

I have the same problem as Frank Pizzardi. Somehow I managed to do some more work in my hidden Workbook, and now I can not reopen other sheets, only UserForm:))

sir when i open another workbook there are many confusion and error how i can hid only one workbook or make excel unable to open another workbook

Nice

Hello Dinesh Sir. How to show this userform when excel opens? How to assign macro to show userform. Please guide.

Sir Make a video to hide the complete data After entering data in userform

Hi, I have done exactly as what you have said but what I still dnt get is why the workbook is not automatically save that is after i input and close and exit the workbook and later open the same workbook the previous input was gone after i input another data.Thanks for your help

Hi there.. I've used the VBA coding which you mentioned. However, now I'm not able open the workbook and worksheets. It only opens the userform, even if i close the Excel completely and try to open, it displays only the userform. Could you help and let me know that how can i retrieve the workbook and worksheet. As I'm not able to view VBA codes as well after pressing alt+11.

Hello sir, can you please advise me the code that close the work book entirely and open whit a short cuts. Regards

is there any way to write urdu language in excel vb?

The problem is that it hides all the open excel files you have. is there something to resolve this?

If you don't make the application visible again, and then you save and close your macro, it seems like you'll never be able to open your macro and edit the code again. I mean, you'll just see the userform and the workbook itself will never be made visible. So there would be no way to access your code. Is that right? Or is there a way to access your code?

Hello Sir how to use old sheets

sir, share some more example about listbox (like selected cell data in one listbox)

Sir, I have forgot to put codes on my close button. Now when I open excel it only shows my Form. How can I get in again into my excel sheet : )

I follow your excel vba tutorial,but I have a problem, I create a user with lebel testbox and combobox. I want if I select option from combox then I put data in differen sheet, I.e year 2017, 2018 after select from combox,then put the data sheet1 for 2017 and sheet2 for 2018

The network is a branched one having so many sub branches..Please help sir

Is there any way to keep excel showing in the taskbar while the application is not visible?

sir , how to do if i want to open userform first then after running all the macro i want to see the result in excel file then if i need change give inputs again in userform and get another result and so on...

can we use userform from another workbook , let say we are not pasting that userform in personal macro

If I put in the VBA code to hide the background worksheet but missed the VBA code to make the worksheets visable again on the close tab is there anyway to fix this without having to start over?

If i close userform then will it close excel too

Sir, What if I want to hide just the excel file while using the userform and not the entire excel application, as, if I use multiple excel files at same time, with this one, undoubtedly userform appears, and it hides complete excel application and because of which Other excel files get hidden and i cant work over those.. Plz guide me if there's a proper solution for this

Sir, Reffering your old videos on youtube i have managed to make userform to add data and its working perfectly. I have entered the VBA code to hide the worksheet and show only userform and that worked too. My problem is how can i open the workbook to view the data i entered from the userform. Now everytime i try to open the worksheet it only opens the userform and not the worksheet.. Please help me

Hello sir, i have a command button in a userform which opens a workbook. User would like to work on the opened workbook but is not able to, as the useform is always on the top ( even after show modal = false ). The useform is bigger in size and covers a lot of space. So we want it to be active but not on top. The workbook should open in foreground and user would like to work on the opened workbook. Not the mention, the userform is still active on the previous excel in background. I want to implement this. The problem i am facing is, the useform is always on top. I have set the show-modal to false. How can i implement this to open a workbook in foreground. And the useform still be active, but go in. Background. Useform.Hide is not much usable because the user needs to switch continously between userform and opened excel to fill details. Kindly help

How to get workbook back while completing vba code

sorry if i used Userform1 .show 0 with Application.Visible = False then open any excel file i can show all excel windows can i keep first windows hidden

hello Sir , iam using the code eRow=sheet1.cells(Rows,count,1).end(xlup).Offset(1.0).row but it Shows error i am sure the code is correct can you help??

How to hide that loading screen

sir, i will be grateful if you help me to make bank reconciliation automatically by VBA. Is there any availability for that?

Hi Sir My VBA code is not working properly if another workbook is opened. Request you help me to resolve this issue

Is it possible to only hide the specific workbook? Because if I do this all other opened workbooks will be hidden as well.

Please, i am facing a huge issue on my work. I need to hide only the form application, when i use this code all the application of other files are being closed. Can you Please help me ? I have already tried to search a lot in the internet but with no sucess

sir I have used almost same command but how to get print of the data which is entered. When i click print the user form get stuck your help in this regard is appricaited

Sir plz describe how to edit excel sheet if userform is hidden. Because after hiding userform the procedure is still running and no key is working during this.

Hi sir, Is there any method not to show workbook from start, I mean while opening only userform will appear but not the workbook???

But this method will hide all other Excel Worksheets which are open! Is there any better way?

What if I want to start in A7?

Sir no other excel sheet open when userform is active please answer how to fix this problem

I have used the same code to hide worksheet but after that i am not able to see worksheet anymore,when i close userform .Video shows that when we close userform automatically worksheet will be visible,Any solution

dear sir, with due reverence, pls update the video how we take the print of only userform instead of excel sheet. sir hum sirf aur userform jo samany show hota bus uska print ly sakty hain if it is possible pls sir update

How to show user form directly desktop as icon

sir can we create .exe file of excel vba workbook???sir please solved this problem....

Sir, I have tried and i have some issue could you give mail id to send my file.

i tried the first now i cant re open and edit my program. :(

It works. But when i open another workbook and close it, the workbook which i want to hide comes up.

Dear Sir, I've tired this code for hiding sheet.. but it is not properly working.. Worksheet becomes populating before opening userform, it means userform not smoothly opens.. Can you suggest me any other option for smoothly opens only userform & hide sheet.. Waiting for your genuine reply... Thanx...

A little difficult

Sir Please say how to hide the work book completely

how to turn it back? i cant open now my workbook T_T