How to Hide Excel and Show Userform ONLY - Excel VBA

Подписаться 98 тыс.

Просмотров 288 тыс.

50% 1

📊 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/

Опубликовано:

2 авг 2013

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 130

@DeadboltDon 7 лет назад

Hey Dan, Just wanted to say thanks for all your work here on RU-vid! 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!

@zarkoandjic7476 9 лет назад

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

@DavLim86 9 лет назад

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

@ExcelVbaIsFun 9 лет назад

David Lim Awesome!

@nilsbruhner1983 5 лет назад

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

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

@nandoxed 7 лет назад

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

@ExcelVbaIsFun 7 лет назад

So glad it helps! Thanks Dan

@dwag5340 3 года назад

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

@samsulfuadmahmud4592 5 лет назад

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

@nomerg2430 8 лет назад

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

@ExcelVbaIsFun 7 лет назад

Glad it helps! Thanks Dan

@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! :)

@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

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

@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

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

@prada004 9 лет назад

Excellent video!!! was really helpful to me

@ExcelVbaIsFun 8 лет назад

+Pradeep Ramkumar So Glad to hear it Pradeep! Dan

@kelliereviews5341 3 года назад

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

@KevinPGA 10 лет назад

You make Excel VBA a BLAST!!!

@ExcelVbaIsFun 10 лет назад

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

@krn14242 11 лет назад

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

@Meolimo 6 лет назад

Love it thks Dan

@brykobe24 4 года назад

Worked perfectly thank you !!!

@ExcelVbaIsFun 4 года назад

Awesome work, Angel!

@roelpanis8711 3 года назад

Thanks, for the wonderful sharing.

@Ayhamtechtips 9 лет назад

thanks Dan this is very helpful

@ExcelVbaIsFun 9 лет назад

Ayham Ayham You're extremely welcome!! Dan

@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

@Radi0he4d1 8 лет назад

This gave me a couple cool ideas.

@ExcelVbaIsFun 8 лет назад

+Radi0he4d1 Awesome!

@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

@automationguide3498 7 лет назад

Thank You !!

@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

@punked101 8 лет назад

thank you sir !

@ExcelVbaIsFun 7 лет назад

Very welcome!

@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

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

@jamesjoule6259 10 лет назад

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

@blackjack03 6 лет назад

Thanks!

@ryanrinn4041 5 лет назад

Love it

@JayeshUllatil 8 лет назад

Brilliant

@ExcelVbaIsFun 8 лет назад

+Jayesh U Thanks!

@alializadeh8195 Год назад

Thanx

@suniltiwari6068 7 лет назад

superb

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

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

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

@ExcelVbaIsFun 11 лет назад

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

@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

@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 :)

@healthtipsonthego 10 лет назад

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

@bounsanongvongphachanh823 Год назад

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

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

@robyxander9760 5 лет назад

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!

@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

@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

@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

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

@ExcelVbaIsFun 10 лет назад

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

@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

@CoopsyCo 10 лет назад

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 :)

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

@ragon747 9 лет назад

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

@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

@behroozkavoshgar7917 3 года назад

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

@roulettemasterseries1175 7 лет назад

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.

@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

@robednarczuk 2 года назад

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

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

@johnwatkins39 10 лет назад

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

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

@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. :(

@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

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

@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

@annapureddymallika6155 7 лет назад

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

@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

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

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

@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

@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

@voeutvor 3 года назад

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

@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

@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

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

@WalyB01 3 года назад

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

@syedahmed4083 8 лет назад

can we hide woorksheet by clicking button

@sachinrana8321 4 года назад

what is this possible vba excel software app

@exceltipsandtricks5763 8 лет назад

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

@tughanozsezer9332 4 года назад

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

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

@CNT12696 6 лет назад

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

@venasoliveira 9 лет назад

Application.Quit

@CoopsyCo 10 лет назад

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?

@Me-ow5rw 2 года назад

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

@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 :(

@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. 👉 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zu3ux1_a4hU.html Thanks Dan

@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