How to Run UserForm without Showing Excel Window

[@limitone9564]

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.

[@thedatalabs]

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!

[@juantoknow]

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.

[@AttackOnTyler]

​@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

[@hinafathima284]

@@thedatalabs hi sir i have some error while closing the userform along with excel application

[@dragosmilea9691]

​@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!

[@culea0alex]

Holly cow, this works and it's so cool. TY very much.

[@Puribalasaheb]

बहोत बढिया

[@ahmedabbas7844]

Thanks for your help 😃☺️

[@querrythis]

Fit me needs perfectly. Thanks

[@khaledmezghani3701]

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

[@alioujalan3378]

awesome trick

[@ynt9011]

I love your video

[@3pehrs]

it is totally helpful and inspiring 😊 thanks 👍

[@ramgella1205]

Thanks Sir this help me a lot

[@ramgella1205]

Sir are you going to download how you create this userform?

[@AjaySharma-em2ez]

Thank you sir, for sharing this great work sir. thank you sir.

[@thedatalabs]

Thanks!

[@Maclan_0709]

Thanks for this greate vba turorial. Do you have a tutorial how to create this form?

[@thedatalabs]

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!

[@Maclan_0709]

@@thedatalabs It's noted, thanks a lot❤

[@saji4385]

@@thedatalabs sir, is this video tutorial already posted. I am waiting to for it

[@ZiadAdly]

many thanks

[@thedatalabs]

Thanks for watching and feedback!

[@imrandaud478]

Wonderful ❤

[@thedatalabs]

Thanks for your feedback!

[@mra893]

Nice

[@rathaprrathapr5131]

very good

[@fabioluiz8677]

Deixando um like e um abraço

[@sachkum]

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.

[@NamHaVblog]

thanks

[@affiliateme7414]

is the floating window type of thing possible with google sheets?

[@daroodurmul5789]

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'

[@Pankajkumar-yv5dr]

Is it passible with Google sheets too

[@abdulnasirafridi]

Development video of this inventory nanagement system share please

[@satishdeshpande1336]

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...👍

[@thedatalabs]

Yes, you can perform all the task as Excel is running in background. Thanks!

[@fayzalikhurshed3398]

Hi, I have some questions how I can contact with you?

[@fooodef]

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

[@samuelasare9387]

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?

[@jungali_boi]

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.

[@edtardaguila3599]

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?

[@syedshahzaibali4729]

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.

[@tusharmali4797]

but another excel file invisible when i open this files i hope you understood my qery

[@gineespina250]

can't download this file. download is broken. can u send another file thx

[@mohamadalqalmawy9054]

I need the excel file please

[@likithsreedhar3996]

❤

[@joshitoshi9835]

bro will u send excel to exe compiler software at my email?

[@sabbirhowlader4325]

I am interest

[@bhavneshparikh8283]

Add in purchase return Sales return

[@sallytong241]

I tried both solutions but in vain. The application has opened first and close right after, then login form show up.

[@nassimgaming4948]

Bro it doesn't need full 12 minute to explain. . Anyway good luck

[@karzanq424]

Is there any other way bro? Guide me.

[@riteshrsimc]

Customisation is not allowed as it is password protected

[@thedatalabs]

thedatalabs

[@MrJamal3771]

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.

[@mosamra3776]

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

[@manishsoni125]

Not working

[@rumeshanjana8167]

This is not working

[@mstechnical1937]

1st 5 mint are wasting Time

[@michaelgalang9550]

2 much cringe in tNice tutorials section xD

[@EvilEyeTheEye]

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...???

[@culea0alex]

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