I don't think this tutorial is complete... so the user clicks the close button then excel shows up? Does not make sense, it should also close the excel. I was also going to ask... if I'm the coder how do I get back to the developer side if excel closes when we hit the close button.
Thanks for your feedback! With the help of current code, you can come to Excel application and do other works if required. This suits both User and Developer if other works required in same workbook. If you want to close the Excel Application along with Userform then remove the two lines existing VBA code and add four lines of new code in UserForm QueryClose sub procedure. So the new code would be: Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) Application.DisplayAlert=False Unload Me Thisworkbook.close Save changes:=True Application.DisplayAlert=True End Sub Let me know if you have any questions. Thanks!
I have done this last year.. Here is the blue print. Upon opening the file. If there are other file were opened. The system promt the user if he continue to use the file(1. all excel file will be hidden) else user must close other files before opening. On the vba form, I put a command(label) for the developer use. And I put a code on the form/command if the form close ❎ then (2. All other excel file will be shown. Hope it helps guys.
@TheDataLabs this creates a memory leak where the only way to close to application is to end Excel in task manager. Also because the code is being ran from thisworkbook, display alerts = true never fires due to the workbook closing before the code can be called. Also Also, if the user doesn't close the app instance using task manager, when they open a workbook, it will bind to the existing instance in memory which has had its visibility set to false. Emails and zoom calls abound
@thedatalabs thanks for this answer. I was looking for the same solution. On the same note, if the developer will ever want to open the application to do some work in the excel spreadsheet, can you please advise how this will be possible? Thanks in advance!
Thanks for this tutorial :) can we apply this trick on only one specific workbook. i.e. when I try to do what you did in this video, all other open Excel workbooks become invisible. I want a specific workbook to become invisible and the others visible as usual Thanks in advance
These tutorials are very useful. I would like to know how can we create a similar data entry form where multiple users can enter data on a shared drive location simultaneously. Every user should be able to see only his data (that he has entered) on the forms list box & not other users data. Also, if the user wishes to download his data, he gets a link label option to download the data to a new excel file. Please can you create a video for performing this activity.
Dear sir.. When the application is hide behind userform.. is it possible to trigger to print specific sheet from button created on userform.. I mean to make PDF for specific sheet....? Waiting you genuine reply...👍
the problem with this code is that if you have multiple excel files opened all of them will be hidden. is there a way that the file which the userform resides will be hidden once you run the code?
excellent job....but how we start user form ...I made a form everything is ok..but when when i clici the excel icont it start with sperad sheet..I want to start the interface of userform at ffirst click..please extend your kind knowledge thanks'
Hello there, I tried this code and its working fine but there is small problem, when I click on the excel file it shows the excel sheet before running the user form.
dear i disable the visiable on close as well , it works but when i open the file again the ecvel sheet show so i need to close and open again to show the form what is the solution
Thank you for your video tutorials. My problem is that your videos are not clear at all. Please can you research and get to know how you can adjust your camera to ensure clarity of video?
Be extra careful when using application.visible = false code coz you may experience runtime automation error that would corrupt the table data and the workbook itself.
How do I know my VBA Project Password, I didn't set up any password while I create my Macro VBA but it keeps asking me to enter the VBA Project password. How do I know that password...???
Now I just saw your pined comment. Well, you can acces your code by pressing Ctrl+break. And if you want to make so that EXEL won't ask you to save the file, here is the code: Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.ThisWorkbook.Saved = True 'Tells Excel that the file has already been saved (this prevents.. '...Excel from requesting that you save the file when you close it) End Sub
I don't think this tutorial is complete... so the user clicks the close button then excel shows up? Does not make sense, it should also close the excel. I was also going to ask... if I'm the coder how do I get back to the developer side if excel closes when we hit the close button.
Thanks for your feedback!
With the help of current code, you can come to Excel application and do other works if required. This suits both User and Developer if other works required in same workbook.
If you want to close the Excel Application along with Userform then remove the two lines existing VBA code and add four lines of new code in UserForm QueryClose sub procedure. So the new code would be:
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
Application.DisplayAlert=False
Unload Me
Thisworkbook.close Save changes:=True
Application.DisplayAlert=True
End Sub
Let me know if you have any questions. Thanks!
I have done this last year..
Here is the blue print.
Upon opening the file. If there are other file were opened. The system promt the user if he continue to use the file(1. all excel file will be hidden) else user must close other files before opening.
On the vba form, I put a command(label) for the developer use. And I put a code on the form/command if the form close ❎ then (2. All other excel file will be shown. Hope it helps guys.
@TheDataLabs this creates a memory leak where the only way to close to application is to end Excel in task manager. Also because the code is being ran from thisworkbook, display alerts = true never fires due to the workbook closing before the code can be called. Also Also, if the user doesn't close the app instance using task manager, when they open a workbook, it will bind to the existing instance in memory which has had its visibility set to false. Emails and zoom calls abound
@@thedatalabs hi sir i have some error while closing the userform along with excel application
@thedatalabs thanks for this answer. I was looking for the same solution. On the same note, if the developer will ever want to open the application to do some work in the excel spreadsheet, can you please advise how this will be possible?
Thanks in advance!
Thanks for this tutorial :)
can we apply this trick on only one specific workbook.
i.e. when I try to do what you did in this video, all other open Excel workbooks become invisible. I want a specific workbook to become invisible and the others visible as usual
Thanks in advance
Holly cow, this works and it's so cool. TY very much.
Thanks for this greate vba turorial. Do you have a tutorial how to create this form?
This form is from Inventory Management System! We are working on that and we will post an end to end tutorial on that. Please keep watching. Thanks!
@@thedatalabs It's noted, thanks a lot❤
@@thedatalabs sir, is this video tutorial already posted. I am waiting to for it
These tutorials are very useful. I would like to know how can we create a similar data entry form where multiple users can enter data on a shared drive location simultaneously. Every user should be able to see only his data (that he has entered) on the forms list box & not other users data. Also, if the user wishes to download his data, he gets a link label option to download the data to a new excel file. Please can you create a video for performing this activity.
Thanks for your help 😃☺️
Fit me needs perfectly. Thanks
Thank you sir, for sharing this great work sir. thank you sir.
Thanks!
it is totally helpful and inspiring 😊 thanks 👍
Thanks Sir this help me a lot
Sir are you going to download how you create this userform?
Dear sir..
When the application is hide behind userform.. is it possible to trigger to print specific sheet from button created on userform..
I mean to make PDF for specific sheet....?
Waiting you genuine reply...👍
Yes, you can perform all the task as Excel is running in background. Thanks!
is the floating window type of thing possible with google sheets?
the problem with this code is that if you have multiple excel files opened all of them will be hidden. is there a way that the file which the userform resides will be hidden once you run the code?
Wonderful ❤
Thanks for your feedback!
excellent job....but how we start user form ...I made a form everything is ok..but when when i clici the excel icont it start with sperad sheet..I want to start the interface of userform at ffirst click..please extend your kind knowledge thanks'
many thanks
Thanks for watching and feedback!
बहोत बढिया
I love your video
Hello there, I tried this code and its working fine but there is small problem, when I click on the excel file it shows the excel sheet before running the user form.
can i ask you a question ❓
i learned to run a program without showing excel. i want to learn a program that closes without showing excel again.
awesome trick
dear i disable the visiable on close as well , it works but when i open the file again the ecvel sheet show
so i need to close and open again to show the form
what is the solution
Development video of this inventory nanagement system share please
Is it passible with Google sheets too
Deixando um like e um abraço
Thank you for your video tutorials. My problem is that your videos are not clear at all. Please can you research and get to know how you can adjust your camera to ensure clarity of video?
very good
can't download this file. download is broken.
can u send another file thx
Nice
Hi,
I have some questions how I can contact with you?
but another excel file invisible when i open this files
i hope you understood my qery
thanks
bro will u send excel to exe compiler software at my email?
I am interest
Bro it doesn't need full 12 minute to explain. . Anyway good luck
Is there any other way bro? Guide me.
Be extra careful when using application.visible = false code coz you may experience runtime automation error that would corrupt the table data and the workbook itself.
I tried both solutions but in vain. The application has opened first and close right after, then login form show up.
I need the excel file please
❤
Add in purchase return
Sales return
Customisation is not allowed as it is password protected
thedatalabs
yeah but this hides any other excel files that are open.. so it's really useless.. or if the user have excel files open, it will hide everything
Not working
This is not working
1st 5 mint are wasting Time
2 much cringe in tNice tutorials section xD
How do I know my VBA Project Password, I didn't set up any password while I create my Macro VBA but it keeps asking me to enter the VBA Project password. How do I know that password...???
Now I just saw your pined comment. Well, you can acces your code by pressing Ctrl+break. And if you want to make so that EXEL won't ask you to save the file, here is the code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ThisWorkbook.Saved = True 'Tells Excel that the file has already been saved (this prevents..
'...Excel from requesting that you save the file when you close it)
End Sub