Hi, this is Wayne again with a topic “Create a Go Full Screen Macro in Excel and How to Create Custom Excel Buttons”.
In this article, i’m going to show you how to create an excel macro from scratch. It’S a simple one, but it’s a macro that will put you into full screen mode whenever you want it to, and this video is one in a series on creating excel macros. Please check out the other macro videos as well so step. One is to go here to the quick access, toolbar and click on this button here and i’m gon na go here to more commands and at this point i’m actually going to switch to customize the ribbon and there’s other ways to get here to customize the ribbon.
But it’s important that you have this option selected developer if developer doesn’t have a check mark next to it. You need to do this step. You need to put that check mark in and what i’m doing here is i’m customizing the ribbon, i’m adding an extra tab to the ribbon. You can see. There are other optional tabs that i could add, but for the purposes of this, video developer is the one that you must have so i’ll click. Ok, now that i have the developer tab, i can click on it here and look on the developer ribbon. I have a code group and there’s some really exciting things you can do here in the code group.
You can record a macro which is really fun and pretty easy to do. I have a video specifically on that that i hope you’ll watch or you can create and manage macros from scratch, and that’s what we’re going to do here. I’M going to click on visual basic to create a vba macro and vba is visual basic for applications. This is programming, but don’t let that intimidate you we’re going to use a simple program. It’S basically like a recipe or a magic spell. However, you want to think about it and i’m going to include the code for this in the description below the video. If you want to copy paste it in, you can do that so you’ll notice here in this project window in the upper left, it says vba project, spanish animals, quiz, that’s the spreadsheet that i’m using and it’s got sheet 1 listed, and it’s also got this. Workbook listed so where do i want this code to be stored in the workbook itself, any sheet in the workbook or in one specific sheet? I think i’ll just put it in the entire workbook, so any additional sheets that i add it should work for. So i’m going to double click where it says this workbook and it brings up a space for me to type in the code that i’m going to use for this vba macro. I’M going to start by typing in the word sub and here i’m basically naming a subroutine i’ll call.
This go full screen and then i’ll put left and right parenthesis i’ll tap, enter on the keyboard and then i’ll type in application, dot display and you’ll notice. As soon as i start typing display, i get a pop-up with options that i can choose from i’m going to browse down, display full screen. That’S what i want to do so i’ll double click on that and then i’ll put equals space and then underscore and then i’ll tap enter and then i’ll type, not space application. Dot display full screen i’ll tap, enter and you’ll see that microsoft vba in excel has automatically put in end sub so end subroutine. At this point i can x out of it and i’m back in excel, and i can now go to my macros button and there’s my macro and we can test it out.
So, with this macro selected, i’m going to click run and look. It takes me into full screen mode, which really might be a helpful thing to do in this case, because this is a worksheet or a quiz that my students are going to take to help them practice. The spanish animal words it’s kind of helpful to go into full screen for this.
I think i’m going to tap escape on the keyboard to get out of full screen, because i want you to see that there’s a much better way to access that macro much better than going here to the macros button. What we can do is set up our own button that when clicked will activate the macro, so i could go here to insert and i could insert a button that way – that’s a great way to go, but as you can see those buttons, don’t always look amazing. They’Re kind of plain, so in this article i want to show you an alternative way to put buttons into your spreadsheets, i’m going to go to insert illustrations, shapes and i’m going to draw out a button. Now you could use any of these shapes.
It could be a star button, a triangle button whatever, but i’m going to go with this rectangle button with rounded corners, so i clicked on it and now i’m going to click and drag on the screen to draw out my button. Now that it’s drawn, i can go here to the shape format, tab that appeared and i can choose the color scheme that i want to use whatever i think looks good, and then i can double click on the shape and i’ll type in full screen tap enter. My text is pretty big, so i’m going to have to stretch out my button a little bit and or shrink the text. Okay, i think that looks pretty good.
If i want to, i could even insert let’s say an icon. I can go here to insert illustrations, icons and i’ll do a search for screen. Let’S say this represents full screen. I’Ll click insert so i can add this icon to the button i’ll shrink it down to a good size and put it right there.
On my button. Now, to make this an actual button that will execute the macro. There’S a couple of more steps we have to do. One would be, i need to group the icon and the button together.
So i clicked on the button now i’m going to hold the ctrl key and click also on the icon, with both selected i can right click and choose group group. Now, that’s all considered one thing, and at this point i can right click on the button again and this time choose assign macro which macro how about this workbook go full screen. I click ok. Now, if i click away from the button, the full screen button is ready to be used.
So let’s say the students are ready to take this practice quiz. I, of course need to clear out the correct answers, but at this point i can click full screen and the spreadsheet goes full screen and the students can begin working with this interactive, worksheet or quiz. If i click full screen again notice that it toggles out of full screen, so that’s a nice feature as well. Now, if you recall, i created this in this workbook, not just sheet one.
So, let’s test that out. If i go down here to the lower left and click the plus sign to add a second sheet, i don’t see my button, but if i go to macros notice that the macro still does exist, all i would need to do is go back to sheet 1 Right click on my button to copy it and then go to sheet 2 right click to paste. Let’S see if it works, i click and it goes full screen. I click again and it takes me out of full screen. So i hope you can see some potential here for using this simple excel macro to create a full screen button, if you’re interested in learning how i created this interactive, worksheet or practice quiz. Please watch my other video on that topic.
Thanks for watching. I hope you found the video to be helpful. If you did please like follow and subscribe, and when you do click the bell so you’ll be notified. When i post another video, if you’d like to support my channel, you can do that through my patreon account, or by buying channel merch and you’ll, see links to those opportunities below the video. Speaking of patreon, i’d like to give a quick shout out to my five dollar patreon supporters.
Thank you. So much for all you do to support my channel. .