Sir! It will get hide when we open this workbook and in middle if we open another excel by keping this user from in open, automatically user form backend excel also will visible. Please check and confirm if I m wrong
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 )
Hi. I've problems in saving the workbook as you suggest.. (I noticed that there a warning that says: In which folder witll the file be saved") and after executing the save i get to an empty screen.. I've also another question: how do you get the blu screen behind the form? thanks for any suggestion
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.
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?
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
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
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, 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.
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
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?
Hi sir, Open your excel file and while your userform is up click on another non macro excel. Close your form and open another excel again. You will have your marcro excel up.
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:))
@@Exceltrainingvideos which vedio we can refer , i made a userfrom to select sheet in a workbook , should i paste this in personal workbook to use it everyworkbook
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
This link will help: www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/ You can also download a sample file for practice.
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...
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?
Hi sir, Open your excel file and while your userform is up click on another non macro excel. Close your form and open another excel again. You will have your marcro excel up.
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
@@Exceltrainingvideos thank you sir for your valuable feedback. By using Useform.hide, the user is not able to work on both userform and excel at same time. The user needs to fill the input in the userform from the excel that he has opened. Kind of switch between userform and opned excel to fill details. I am unable to achieve that because with useform.hide, the userform is hidden and there is no way to switch between two excels. Kindly help me sir.
You have to activate the workbook in which you have the macro. This Excel VBA tutorial will help: www.exceltrainingvideos.com/how-to-consolidate-data-from-multiple-excel-workbooks-using-vba/
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
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
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
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...
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??
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 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.
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
Nahi ker sakte. Userform ka print le ker Kya karoge. Ager uska print chahiye to opened userform ka screenshot lo, phir paint me save kerke, paint se print nikalo...
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
It's a good idea to keep a copy of the workbook in which you wish to try a new macro. This link will help: www.exceltrainingvideos.com/automaticcally-hide-workbook-view-user-form/
this video is what I've been looking for for so long
Great you found this Excel VBA tutorial helpful! Please share with your friends too.
Sir! It will get hide when we open this workbook and in middle if we open another excel by keping this user from in open, automatically user form backend excel also will visible. Please check and confirm if I m wrong
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.
Hi. I've problems in saving the workbook as you suggest.. (I noticed that there a warning that says: In which folder witll the file be saved") and after executing the save i get to an empty screen.. I've also another question: how do you get the blu screen behind the form? thanks for any suggestion
the video is great, simple and clear. i can't wait to try it.
Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/
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.
Hello Dinesh Sir. How to show this userform when excel opens? How to assign macro to show userform. Please guide.
So simple and well explained... kudos ir...
Glad you liked it
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?
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
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.
This was another great tutorial. You're the best
Glad you think so! Please share the Excel VBA tutorial with your friends also on social media.
Nice simple explanation. Thank you.
Glad it was helpful!
awsome tuto man... good simplicity
Glad you liked it! Please share the Excel VBA tutorial with your friends also on social media.
Thnk you for your teaching. I like it
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
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?
Hello,
Do we have ability to use excel to start or stop windows server services?
This was very useful. Thanks!!
You are welcome. Sharing is caring!
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
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
Sir
Make a video to hide the complete data
After entering data in userform
Wonderful Mr. Takyar
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.
When you work with VBA code please make a copy of your original work.
Very good 👍. Keep it up
Thanks a lot 😊. Please share the tutorials with your buddies.
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
Create a button on the user-form and on click it should display the application (Excel Workbook) like so:
Application.Visible = True
@@Exceltrainingvideos Thank you sir. Your videos are really helpful
Thank u sir for sch a great video
So nice of you! Please share the VBA tutorial with your friends also on social media.
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?
Hi sir, Open your excel file and while your userform is up click on another non macro excel. Close your form and open another excel again. You will have your marcro excel up.
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:))
Thank you Sir.
Welcome!
The problem is that it hides all the open excel files you have. is there something to resolve this?
can we use userform from another workbook , let say we are not pasting that userform in personal macro
Yes.
@@Exceltrainingvideos which vedio we can refer , i made a userfrom to select sheet in a workbook , should i paste this in personal workbook to use it everyworkbook
If i close userform then will it close excel too
sir, share some more example about listbox (like selected cell data in one listbox)
OK. You may also like to refer to www.exceltrainingvideos.com/
really usefull
is there any way to write urdu language in excel vb?
Thank you that was so helpful
Hello sir, can you please advise me the code that close the work book entirely and open whit a short cuts. Regards
Search www.exceltrainingvideos.com
The network is a branched one having so many sub branches..Please help sir
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 : )
press alt F11 and change your code
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
This link will help: www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/
You can also download a sample file for practice.
Hello Sir how to use old sheets
Excellent
Thanks! Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/
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...
Search the channel or search www.exceltrainingvideos.com
sir, i will be grateful if you help me to make bank reconciliation automatically by VBA. Is there any availability for that?
+mohamed helemish www.exceltrainingvideos.com/bank-reconciliation-using-excel-vba/
Thanks sir, But that's doesn't meet my requirements.
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?
i dont thinks hes answering back lol have the same problem as urs. LOL
Hi sir, Open your excel file and while your userform is up click on another non macro excel. Close your form and open another excel again. You will have your marcro excel up.
@@joelabaring3995 thanks bro
How to hide that loading screen
Is it possible to only hide the specific workbook? Because if I do this all other opened workbooks will be hidden as well.
Try it out and give feedback.
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
On the worksheet place a form button and attach it to
UserForm1.Show
On your UserForm1 place a button to hide the user-form like so:
Me.Hide
@@Exceltrainingvideos thank you sir for your valuable feedback.
By using Useform.hide, the user is not able to work on both userform and excel at same time.
The user needs to fill the input in the userform from the excel that he has opened.
Kind of switch between userform and opned excel to fill details.
I am unable to achieve that because with useform.hide, the userform is hidden and there is no way to switch between two excels.
Kindly help me sir.
How to get workbook back while completing vba code
Thank you
What if I want to start in A7?
You can.
@@Exceltrainingvideos How? Pls teach me.
sir can we create .exe file of excel vba workbook???sir please solved this problem....
No but you can create an add-in.
Sir please make a tutorial on that..thank you sir
Hi Sir
My VBA code is not working properly if another workbook is opened. Request you help me to resolve this issue
You have to activate the workbook in which you have the macro. This Excel VBA tutorial will help: www.exceltrainingvideos.com/how-to-consolidate-data-from-multiple-excel-workbooks-using-vba/
Hi sir,
Is there any method not to show workbook from start, I mean while opening only userform will appear but not the workbook???
That's what this video demonstrates!
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
But this method will hide all other Excel Worksheets which are open! Is there any better way?
Application.Windows(ThisWorkbook.Name).Visible = False
Application.Windows(ThisWorkbook.Name).Visible = True
@@alperduryaz tnks
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
This link will guide:
www.exceltrainingvideos.com/automaticcally-hide-workbook-view-user-form/
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
+Sukhdev Jadeja Have a look at this link for printing: www.exceltrainingvideos.com/automatically-search-excel-data-display-print-using-vba/
+Dinesh Kumar Takyar thanks sir.
sir i need VBA code to get border style automatically when data is entered and when data is deleted border style to be removed automatically
Thank you
Sir no other excel sheet open when userform is active please answer how to fix this problem
That's what the video is about!
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...
This link to the Excel VBA tutorial will help: www.exceltrainingvideos.com/automaticcally-hide-workbook-view-user-form/
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??
The code you've typed is not correct. Please check it again.
rows.count not rows,count
rows dot count Not rows comma count...
Theres the mistake..
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
Try this:
On the worksheet place a form button and attach it to
UserForm1.Show
On your UserForm1 place a button to hide the user-form like so:
Me.Hide
It works.
But when i open another workbook and close it, the workbook which i want to hide comes up.
Try again.
@@Exceltrainingvideos did it... Still the same..
same issue happens with me
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.
UserForm1.Show vbModeless
Watch this video: ua-cam.com/video/Fy4TYNmUWak/v-deo.html
Nice
Please share the Excel VBA tutorial with your friends too. Thanks.
thank you very very very much because this program "work"
+Djebbi Abdellatif 100% of my code works if you check your code against my code carefully. Thank you!
How to show user form directly desktop as icon
My current knowledge is that the User-form is part of Excel.
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
Nahi ker sakte. Userform ka print le ker Kya karoge. Ager uska print chahiye to opened userform ka screenshot lo, phir paint me save kerke, paint se print nikalo...
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
Did you code the 'Close' button?
Sir Please say how to hide the work book completely
Will bake a video on this soon.
Sir, I have tried and i have some issue could you give mail id to send my file.
takyardinesh@gmail.com
i tried the first now i cant re open and edit my program. :(
It's a good idea to keep a copy of the workbook in which you wish to try a new macro. This link will help: www.exceltrainingvideos.com/automaticcally-hide-workbook-view-user-form/
A little difficult
how to turn it back? i cant open now my workbook T_T
www.exceltrainingvideos.com/automaticcally-hide-workbook-view-user-form/
We should always make a backup of the file when we wish to work with macros.
@@Exceltrainingvideos that's ok sir.. but how to return back to workbook??