How to Hide Excel and Show Userform ONLY

How to Hide Excel and Show Userform ONLY - Excel VBA

Рет қаралды 287,804

11 жыл бұрын

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
Learn how to make your Excel program look more like a regular program - with Excel being hidden and your Userform being on display only! This is a HUGELY requested topic and there are several things to keep in mind when setting this up, but it's not that difficult. Check it out!!!
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/

Пікірлер: 130

@DeadboltDon 8 жыл бұрын

Hey Dan, Just wanted to say thanks for all your work here on KZfaq! With your vba basics track I went from zero vba experience to completing a nasty project I've wanted to do for years in only a week! This video in particular was really helpful! Thanks man!

@horneroutdoors7368 9 жыл бұрын

i really like this. my next question for you now is... How can I get the userform to show as a button in the taskbar on my windows screen? it would be nice to not have to minimize or hide the userform to switch back and forth between windows

@zarkoandjic7476 9 жыл бұрын

Thanks. This helped me with my macro User Form. All the best.

@markwmscym 5 жыл бұрын

Really great tutorial thanks. It was the closest thing I could find to what I was looking for. I created a budget spend tracker for employees in the company I work for. I have frozen cells to make sure they can’t edit stuff their not meant to, but I also wanted to hide the toolbar and spreadsheet tabs at the bottom. The only things I wanted the employees to see when they opened the file was all the cells and vertical scroll bars. I am convinced you can’t do this in excel, unless someone can tell me anything different. Thanks again

@hurley954 7 жыл бұрын

Fast, awesome tip. I'm subscribing because I have wanted to do this in the past and not found what I wanted (to hide the application altogether) through searching. Now I've fortunately stumbled upon the video.... if only I had a few months ago!

@ayoublahjou5917 8 жыл бұрын

Hello ^^ i wonder if you know howe to hide only one woorkbook instead of closing all excel files. Thank you for the video very helpful

@samsulfuadmahmud4592 5 жыл бұрын

I like the way u explain. It's full of fun learning excel in this way

@ExcelVbaIsFun 10 жыл бұрын

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

@aero70charlie 6 жыл бұрын

Dan, how do I become a member to see your files in DropBox?

@DavLim86 9 жыл бұрын

Thank you! This is what I needed to interact with the workbook. Thank!

@ExcelVbaIsFun 9 жыл бұрын

David Lim Awesome!

@dwag5340 3 жыл бұрын

Wooowww. You have a wonderful way of explaining VBA. THIS IS A GREAT VIDEO AND YOUR EXPLANATION IS WAY SUPER EASY.

@jamesjoule6259 10 жыл бұрын

Thankx for you videos !. I am from Argentina !. Haven't check out all but do you have something related to files ?...

@nandoxed 7 жыл бұрын

Exactly what I was looking for! You're a genius! 🙌🏻

@ExcelVbaIsFun 7 жыл бұрын

So glad it helps! Thanks Dan

@nilsbruhner1983 5 жыл бұрын

Amazingly nice... EXACT the vid i was looking for. THX!!!!

@nomerg2430 8 жыл бұрын

Wow! First time I saw this script, you are brilliant!

@ExcelVbaIsFun 7 жыл бұрын

Glad it helps! Thanks Dan

@aplummer9670 2 жыл бұрын

I have been looking for a way to hide the workbook for days that doesn't require a large amount of code. This is the easiest approach to this that I have seen, Thank you!

@ExcelVbaIsFun 2 жыл бұрын

I'm so glad it helped you, Angela!!

@krn14242 11 жыл бұрын

Cool, thanks Dan. This will be added to my "toolbox".

@kelliereviews5341 3 жыл бұрын

Thank you so much.... Im just getting back into VBA coding. This works like a charm!!😎😎😊

@Ordi2005 6 жыл бұрын

Hello Dan. Thanks for the video! Could you please show what the code would look like if I wanted to leave more than one sheet visible? Let's say I want to veryhide 8 sheets and leave 5 visible. Thanks a lot!

@iamdrdeath 10 жыл бұрын

As usual! Great tutorial ;) have you found a way of getting an icon/picture into the title bar of a userform? That'd be the icing on the cake for a VBA project! Does excel function 100% with the status set to not visible for example SQL connections and sheets population etc? If so then this is the way forward to developing a seemingly stand alone project.

@Meolimo 6 жыл бұрын

Love it thks Dan

@regal_7877 4 жыл бұрын

I know I'm late, but this is very cool. Thanks a lot. I have a question though, Can I make the userform into something like a dashboard, where I display my graphs and charts and everything (with colour, images and formatting), and hide the raw data and calculation in the excel sheet to the background. Does this same method work?

@automationguide3498 7 жыл бұрын

Thank You !!

@prada004 9 жыл бұрын

Excellent video!!! was really helpful to me

@ExcelVbaIsFun 8 жыл бұрын

+Pradeep Ramkumar So Glad to hear it Pradeep! Dan

@KevinPGA 10 жыл бұрын

You make Excel VBA a BLAST!!!

@ExcelVbaIsFun 10 жыл бұрын

No, you do. lol Thanks Kevin Carter!!!

@milododds1 2 жыл бұрын

Dan, you rock!!! This is exactly what I need for something I'm working on.

@ExcelVbaIsFun 2 жыл бұрын

Thanks, Jaw Harping! Glad it's helping you! :)

@roelpanis8711 3 жыл бұрын

Thanks, for the wonderful sharing.

@Stuwie2x2 7 жыл бұрын

Thanks, because of this I can now put a button on my excel file which will run the VBA program. No need to alt + f11 ja then f5. Thanks !

@ExcelVbaIsFun 7 жыл бұрын

+Omertha very welcome, Omertha! Thanks Dan

@Ayhamtechtips 9 жыл бұрын

thanks Dan this is very helpful

@ExcelVbaIsFun 9 жыл бұрын

Ayham Ayham You're extremely welcome!! Dan

@Radi0he4d1 8 жыл бұрын

This gave me a couple cool ideas.

@ExcelVbaIsFun 8 жыл бұрын

+Radi0he4d1 Awesome!

@punked101 8 жыл бұрын

thank you sir !

@ExcelVbaIsFun 7 жыл бұрын

Very welcome!

@albeehernandez7920 8 жыл бұрын

Hi.. if you do this code.. all your excel file will not be visible... do you have a code that it only hide the excel owner of the userform?

@ulayaz 8 жыл бұрын

i have problem on some data on the worksheet, the given data was to be sorted out such that you have to select different columns on the same row then copy to another worksheet loopin' out i think you got me. hope you will help me

@brykobe24 4 жыл бұрын

Worked perfectly thank you !!!

@ExcelVbaIsFun 4 жыл бұрын

Awesome work, Angel!

@blackjack03 6 жыл бұрын

Thanks!

@luanoliveira6643 3 жыл бұрын

I really appreciate your help on this video. I am searching how can I hide just the file that have just opened without hiding the other excel files that already are opened. Could you help me?

@bounsanongvongphachanh823 Жыл бұрын

Hi Dan, can you do on print preview mode with hide manu but show only single print button

@onegoldenpharaoh 7 жыл бұрын

Thank You for your tutorials they are very very helpful and God Bless you as well.

@ExcelVbaIsFun 7 жыл бұрын

Hi David, You're very welcome! So glad it helps! Thanks Dan

@onegoldenpharaoh 7 жыл бұрын

Hi Dan, To begin with I'm a newbie to VBA. I've been watching your videos here and there and I've created a nice form using your codes but I'm having problems 1) Hiding application and just showing the form. Using Excel 2011 on a Mac 2) Adding a delete and search button. If you can Link me to one of your videos that showed that It would be great. oh By The Way English is my second language so bare with me :-) Thanks so Much David

@kennyowz 8 жыл бұрын

is there a way to launch a workbook AUTOMATICALLY after startup (of the PC) at a selected time or even date?

@AP-he7bf 7 жыл бұрын

application.visible = false also prevents adding data to a worksheet while 'false'. The only workaround I found was entering data into a closed file or unhiding the application prior to data entry briefly.

@ebrahimlaila397 5 жыл бұрын

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

@ryanrinn4041 5 жыл бұрын

Love it

@hellowhat999 5 жыл бұрын

Hi Dan (I assume that is you name)First let me acknowledge that your daughter must be 5 years older than when you posted this video and one hear her expressing her happiness..The video was certainly was very helpful.Thank you very muchWish you and your family happiness and may you be blessed what Good you desire.Kassam Juma

@behroozkavoshgar7917 3 жыл бұрын

Hi, How to monitor the dimensions of the userform to the size of the entire screen(after opening the excel file)?

@suniltiwari6068 7 жыл бұрын

superb

@b3lg4r4th8 5 жыл бұрын

Hi Dan,This looks really good. However, I only want the workbook that is related to the user form to be hidden. When the user clicks submit to update the workbook, I want both the userform and the workbook to close. I also want to be able to see the workbook myself so that I can check progress and run statistics on the workbook. At no time should a user be able to see the workbook.

@robyxander9760 6 жыл бұрын

Hi :) I’m currently working on a excel file and what I want to do is a master file that will allow me to extract data and produce a report. On the other hand, I want my employees to use another excel file to record their individual productivity. Can you help me with that please? Also I want the employees file to be limited to recording of productivity only meaning they can’t do other things on it like delete or edit the time they started etc., Thank you in advance!

@CoopsyCo 11 жыл бұрын

Hi love your video but please can you help. How do you hide the excel but keep other excel workbookss from hiding? Also i want application.quit to only quit the active workbook only and keep other open. many thanks :)

@JayeshUllatil 8 жыл бұрын

Brilliant

@ExcelVbaIsFun 8 жыл бұрын

+Jayesh U Thanks!

@TheBoss41895 7 жыл бұрын

This was very helpful thank you! I have one question, what if I want to open user from from icon saved on desktop? The user form will have hidden excel from the beginning. Is it possible? Basically, what I am asking is, is it possible to open only user form like the one in video but not to open (be visible) excel spreadsheet?

@ExcelVbaIsFun 7 жыл бұрын

The userform is contained within the Excel application. You can't open only it without the Excel file to open as well. Thanks Dan

@alializadeh8195 Жыл бұрын

Thanx

@andrewmatthews1369 5 жыл бұрын

So Dan. I have 12 workbooks that have the same structure but they have variables in each of them that are different to each other. I have my userform that appears on my first workbook. It has 12 buttons on it. I want to be able to open up each workbook associated to each button from the user form. Any ideas

@ragon747 9 жыл бұрын

Can I do that using Word VBA? Or this "visible = false" only works on Excel VBA?

@nikiss8 6 жыл бұрын

good tip. for some reason i get 3 windows popping up. i have to open a file and then close each of the new instances of excel. :(

@johnwatkins39 10 жыл бұрын

Can use this same feature to hide and unhide a button?

@roulettemasterseries1175 8 жыл бұрын

is there any way to link the modules into a userform botton?

@michaelmeisman4731 9 жыл бұрын

I have an existing Excel file that has several pages. How do I integrate this to that page? I have tried what you mention here and I get nowhere on it.

@yashp 5 жыл бұрын

hey how do you print a listbox in excel vba ps i want to print it exactly how it looks like that is why i want to print the listbox

@sridharkrishnappanavanerth3388 4 жыл бұрын

Very nice video sir, I am working on a inventory project were i have text box for 'ID'. ID is of the format ST-AUG-0001, I wish to increment the month from AUG to SEP to NOV etc after each month and also increment sequence 0001 to 0002....very time i click on transfer button in user form. please explain with a video, this is very urgent for me. Thank you in advance.

@collinmorris8467 5 жыл бұрын

I have a workbook and when I save and close I want to Break Links to the saved file. Can it be done if so how.

@robednarczuk 2 жыл бұрын

Hey man, how can i get the userform to show a icon in taskbar?

@chuppachimp916 8 жыл бұрын

Thank you for posting. I can see how I could use this as an entry point to an excel based database. Very grateful :)

@MrTwixraider 7 жыл бұрын

first i thougt that this is a great function. But if there are more then one workbook open, then after Application.Visible = True, it brings a random workbook in front. How can I provide that the corresponding workbook comes in front.

@TheSal0mon 5 жыл бұрын

That's fine, but isn't the case whereby "application" you are referring to whole Excel applications? What if the user wants to have other applications opened at the same time? Isn't "window" a better option to use?

@ExcelVbaIsFun 11 жыл бұрын

Thank you! I'm glad you 'like'. lol. thanks! Dan

@yanhon7022 10 жыл бұрын

I have applied this hide&unhide to show the userform directly when open my workbook, but when I open another workbook, they are being hide also. How can this problem be fixed?

@annapureddymallika6155 7 жыл бұрын

how to display a table in data grid view in VBA excel

@Anntenna84 5 жыл бұрын

Hey, i forgot to setup the click me button which is supposed to open the application. So, how can I open it again? Pls help

@muhannad_youssef 6 жыл бұрын

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

@healthtipsonthego 10 жыл бұрын

Got to love it... Hot digadi!!!ha ha

@omw9965 7 жыл бұрын

I guess the reason people might thumbs down depends on what u put in your tags, because I understand what you intension was and its fine but, my seach was "hide database list excel" but your video showed up in the first ten, what I need is when I have a list of customers and I put in a custom search box which I already put in, is there a way to hide the list and only show the search box so that when you do a search the only thing that shows up is the results if any. Is there a way for that? vba not needed

@sidior12 7 жыл бұрын

What if I want to open the user form to be able to be launched from the desktop without accessing Excel? I don't want the user to see Excel, but simply launch the userform from a webpage or their desktop without ever accessing or seeing Excel. How do i do that?

@yashp 5 жыл бұрын

Change the app icon

@lauriemerrill419 7 жыл бұрын

If I have multiple sheets in a workbook, can I control which sheet opens when I re-open my workbook? I have a specific sheet I wish it would default to. It has the main piece of information and the other sheets support the main sheet. (Hopefully this makes since. I have google'd this with no luck.)

@joep9617 7 жыл бұрын

This is called a Workbook_Open event. You could also call a Workbook_Close event to set up the sheet prior to closing (in this way, if someone disables the macros upon opening, it will start where it left off). Leave it how you want it to be found ;-) **** "Make sure your Private Sub Workbook_Open() subroutine is pasted inside of the This Workbook object and NOT in a Module, Form, or Sheet object." Stackoverflow.com Open VBA editor Under the Project window, Double-click or Select "ThisWorkbook" and paste this code and edit as needed... Private Sub Workbook_Open() Worksheets("Sheet2").Activate 'select whatever sheet & cell ranges you want Range("B2").Select End Sub Private Sub Workbook_Beforeclose(cancel As Boolean) Application.DisplayAlerts = False Worksheets("Sheet2").Activate Range("B2").Select End Sub

@visormove 8 жыл бұрын

Nice explication. I have a question. How can I show a excel sheet in a userform??? only is necesary 5 columns and 5 rows Thank you in advances

@Asim593 8 жыл бұрын

+Felix Falconi Add listbox with five columns.Search multicolumn listbox in google. than you can fill data with VBA code from your sheet to this listbox.

@visormove 8 жыл бұрын

That's right, what I mean is if you can see a part of the sheet on a userform excel and work in this part as if it were the same excel sheet. sorry

@syedahmed4083 8 жыл бұрын

can we hide woorksheet by clicking button

@friendsbrn 10 жыл бұрын

Dan, great video! Thanks so much for sharing. However I've run into a bit of a problem: I've combined this "hide Excel" type of function with that of another one of your videos where the user can activate Print Preview from the userform. However, when I press my command button into which I've coded the print preview function (similarly to your checkbox enabling print preview), I get nothing and my userform locks up. I keep getting the "ding" noise regardless of where I click on the userform. Do you have any thoughts or suggestions on why this happens and/or how to fix it? Print Preview works fine in the debug mode, it's only when the workbook is hidden that it gives me the problem. Thanks in advance!

@ExcelVbaIsFun 10 жыл бұрын

Ben, thanks for the comments! Printpreview doesn't work well if Excel isn't active and if the userform isn't unloaded or at least hidden. Make sure that me.hide or unload me is used to get the focus off the userform. Secondly, you may have to do one or all of the following temporarily to show the print preview: application.visible=true YourWorksheetVariable.visible=true YourWorksheetVariable.select AND OF COURSE YourWorksheetVariable.printpreview Happy Coding! Dan, www.excelvbaisfun.com

@friendsbrn 10 жыл бұрын

ExcelVbaIsFun Dan, you are the man! You have successfully turned a mechanical engineer with the coding skills of a slug into a coder who can make awesome userforms with fairly complex functionality (that greatly enhance their utility)!! I tip my hat to you sir!

@ExcelVbaIsFun 10 жыл бұрын

Jeepers, thanks Ben. Be sure to check out my new course on Barcoding in Excel VBA on Udemy! It's a winner! :) give it a look at www.udemy.com/barcodes-excelvba/ Thanks for the comments, Dan

@MrJohnnew2 8 жыл бұрын

Hey all. Anyone know how i can re-access my workbook having locked myself out. I had followed the video and set my userform to show right after the application went invisible then I put a "application.quit" in the queryclose sub all the close buttons on the userform fully quit excel and now I can't access the workbook to correct it. I had put an "unhide application" button on the form so i can unhide it but even thought i can see it behind the userform, i cant do anything with it. desperation here.....please help

@ExcelVbaIsFun 8 жыл бұрын

you should be able to open your workbook with macros disabled if you hold the Shift key down before double clicking on your workbook to open it. if that doesn't work immediately and you don't want to shut down your computer, you could out of desperation go into file options and disable all macros and then reopen the file. Thanks Dan

@ExcelVbaIsFun 11 жыл бұрын

If the name of your workbook is "Book1", then 1. to hide current wb: Windows("Book1").Hide 2. to close it: Workbooks("Book1").Close

@mdatikurrahman8198 6 жыл бұрын

Hello sir, I am a learner. I have added workbook open event to show my userform and hide excel sheet and it's working fine but problem is- how can I go to excel worksheet again? I have not add any button in my userform to show excel worksheet. Is there any way to go to code module? Thanks in advance

@ExcelVbaIsFun 6 жыл бұрын

Hi Atikur, This is the inherent problem with doing this method. As you make mistakes like not adding a button to restore excel for your debug/programming purposes, you may need to force close the program in Task Manager, thus losing your progress (unless something was recently autosaved). Thanks Dan

@lovelyjaimen8557 9 жыл бұрын

Hello, i just want to ask o rather asking for help because I almost memorise all the steps but my prob' is... WHERE DO I CAN OPEN IT??? Where I'm going to start because my lappy is 2007 then if I press the Alt F11, its just the "sound" adjustment only... Let me know please ;-(

@ExcelVbaIsFun 9 жыл бұрын

Lovely Jaimen Hi Jaimen. That's an interesting problem. If you have the developer tab, you should be able to click the button "View Visual Basic Editor" or just "Visual Basic Editor". That's what holding Alt and then pressing F11 key normally does, when excel is open and running.

@voeutvor 3 жыл бұрын

why it do not work when i try to do follow you. (point frmform.show)

@exceltipsandtricks5763 8 жыл бұрын

It´s not difficult to disable that X button.Put this into the queryclose sub If CloseMode=0 Then Cancel=True

@kunalbajaj4028 6 жыл бұрын

When I click on Userform in VBA, Excel crashes. Tried this several times. Has anyone else experienced this and how did you resolve this issue?

@CoopsyCo 11 жыл бұрын

Thank you for replying back to my prev question. The code has been rattling my brain since i saw this video last week. Say for example i have Workbook 2 open (no code) just a simple spreadsheet. I then open up Workbook 1 (with the auto hide excel feature added) it will also hide Workbook 2 and any other excel applications open. I also hijacked the X button on the userform to quit excel but i only want it to close Workbook 1 and leave workbook 2 visible (never hidden) if that makes sense?

@sachinrana8321 4 жыл бұрын

what is this possible vba excel software app

@CNT12696 6 жыл бұрын

That contingency code did not disable the X button on excel 2015

@WalyB01 3 жыл бұрын

Open userform open opening excel. Close excel when closing userform. oops. How do i acces my code now?

@Me-ow5rw 2 жыл бұрын

This option hides all workbooks, How to disappear only the macro enabled workbook and other opened excel files should be open

@tughanozsezer9332 4 жыл бұрын

İf she is happy, we are also happy 🤣🤣

@venasoliveira 9 жыл бұрын

Application.Quit

@mohammedalboainain9826 2 жыл бұрын

Thanks. But the problem is that when starting Excel, it shows for a second before it hides, and that's what needs to be solved.

@ExcelVbaIsFun 2 жыл бұрын

Hi Mohammed, I have a solution for you! I'm filming and will upload as soon as I can.

@alih9435 2 жыл бұрын

@@ExcelVbaIsFun Great.. Keep on the good work 👍

@mohammedalboainain9826 2 жыл бұрын

@@ExcelVbaIsFun Thanks. Can you please notify me when you did?

@ExcelVbaIsFun 2 жыл бұрын

Hi Mohammed, sorry for delay. This video is still Unlisted, but you've waited a long time, so I wanted you to have early access to it. 👉 kzfaq.info/get/bejne/sNtjqNtixMeYmIk.html Thanks Dan

@NewYears1978 9 жыл бұрын

Love the videos very helpful but you need a new mic or something so it doen't have breathing and popping sound. I have misophonia so I can't watch your videos :(

@Txhuayamhloovrawscaijnyoog 5 жыл бұрын

You need to zoom so everyone can see clear

@ExcelVbaIsFun 5 жыл бұрын

Hi Mengxiong, Thanks for the comment! Sorry this was not zoomed/panned as well as more current videos. It was back in 2013 when I was getting started and mobile viewership was not as common as it is now. We all use tiny little screens these days. Fortunately, it was in HD, so hopefully you'll be able to glean what you need, my friend! Thanks Dan

@Txhuayamhloovrawscaijnyoog 5 жыл бұрын

@@ExcelVbaIsFun oh really friend? No problem friend current I'm trying to study Excel so need to learn more and more