Excel vba hide multiple shapes

If I insert a shape called oval 1 in a sheet and run the code: Sub hideshape () With ActiveSheet.Shapes (Oval 1).Select With Selection.Visible = False End With End With End Sub the shape disappears but when I run this cod Re: VBA to Show/Hide multiple shapes based on cell values. The attached VBA subroutine looks at all the 'Shapes' on the active sheet and displays the results in the 'Immediate Window'. You should be able to adapt this to your situation. Please Login or Register to view this content. Register To Reply For example, you want to unhide a certain shape when entering number 1 into cell A1, or hide this shape if cell A1 is other values. Please run the following VBA code to achieve it. 1. Right click the sheet tab which contains the shape you will hide or unhide, then click View Code from the right-clicking menu Next right click 'ThisWorkbook' and click 'View Code'. Copy and paste the following macro into the empty code window: Code: Private Sub Workbook_Open () Sheets (Sheet1).Shapes.Range (Array (Rectangle 1)).Visible = False End Sub. Change the name of the rectangle to suit your needs. Save the file as a macro-enabled file and then close it The Selection Pane in Excel can enables you to hide or show all or partial objects in active worksheet. 1.Click Home > Find & Select > Selection Pane to open the Selection Pane.See screenshot: 2.After opening the Selection and Visibility task pane, all of the objects in the active sheet have been listed in the pane. If you want to hide all of the objects, you just need to click Hide All button.

Hide or Show All Objects with VBA You can also use an Excel VBA macro to achieve the same result of hiding or showing all objects in the current worksheet. Here are the steps: #1 open your excel workbook and then click on Visual Basic command under DEVELOPER Tab, or just press ALT+F11 shortcut These shapes are grouped together in a group called ShapeGroup In the Selection Pane, if I hide Shape1 and Shape3 then click to hide ShapeGroup it will hide the whole group of shapes. When you click to unhide ShapeGroup, it will show only Shape2 and Shape4 since those were visible prior to hiding the group and the other two were not Delete or Hide one shape Because all objects/controls are a member of the shapes collection we can use this to delete or hide one button, picture or ? Sub Delete_One_Shape () ActiveSheet.Shapes (YourShapeName).Delete End Sub Sub Hide_One_Shape () ActiveSheet.Shapes (YourShapeName).Visible = False End Su

Making shapes invisible/visible in excel through VBA

  1. Download the Excel File. Download the Excel file that contains the VBA macro code. Hide Unhide Multiple Sheets Macro.xlsm (16.6 KB) Unhiding Sheets is a Pain. Do you have any workbooks that you have to hide a bunch of sheets before sending them to other users or co-workers
  2. Matlas. 233. I have the following code I'm using to show/hide multiple shape groups in Excel 2016 using VBA and macros: Sub Pic_1_SA_click () ActiveSheet.Shapes (Group 23).Visible = True. ActiveSheet.Shapes (Group 71).Visible = False. ActiveSheet.Shapes (Group 19).Visible = False. ActiveSheet.Shapes (Group 20).Visible = False
  3. Working with multiple shapes. There are two main ways to work with a number of shapes at the same time: by using the ShapeRange object, or by looping over a collection of shapes. Most Microsoft examples use the first method (the ShapeRange object); I find the second much easier to work with, however. Examples of both are shown below

VBA to Show/Hide multiple shapes based on cell value

Note. If you want to do something (like delete or set a property) to all the shapes on a sheet at the same time, select all the shapes, and then use the ShapeRange property on the selection to create a ShapeRange object that contains all the shapes on the sheet, and then apply the appropriate property or method to the ShapeRange object Select multiple worksheets > Right-click on one of the selected worksheets > Hide 1. Press and hold the Shift key and select the worksheets that you want to hide. Note: in this example we are hiding three worksheets (Sheet1, Sheet2 and Sheet3) Remarks. Although you can use the Range property to return any number of shapes, it's simpler to use the Item method if you only want to return a single member of the collection. For example, Shapes(1) is simpler than Shapes.Range(1). To specify an array of integers or strings for Index, you can use the Array function. For example, the following instruction returns two shapes specified by name The above code will check name of each worksheet & if the name is found other than Sheet1 then it will run & hide the sheet. After executing the macro; we will get Sheet1 as visible to us & rest will be hidden. To be able to view sheet1 & sheet2 only out of 100 sheets, you need the following code Sub HideSheets2 ( This quick video shows how to hide and show shapes or objects in Excel VBA using macros. I go over how to make a button to run the code and how to make the c..

The following examples demonstrate how to place a picture in relation to a shape using VBA. Place image next to the upper right corner of a shape. These VBA lines change the position of the image to the upper right corner of the shape. The picture name is Picture 1 and the last line below makes it visible. 'The With. Use the properties. .visible = true and .visible = false. ActiveSheet.Pictures (Picture 2).Visible = True. Answer 2 / 4. madambath. May 11, 2010 at 01:35 AM. Thank you, this requires to execute the Code to do the job. What I need is when the file is opened the Sheet should not show some of the Autoshapes or Pictures in the sheet and keeps. Tip 2: Use a Worksheet variable. For some reason, VBA doesn't support autocompletion that well when you're working with worksheets. For example, as you type in the following lines of code you won't see any Intellisense to help you: 'neither of the following autocompletes. Worksheets (1).Shapes.AddShape 1, 1, 1, 1, 1 If you already have one or more shapes selected, click on the Format tab, and then the Selection Pane button to toggle on the Selection Pane. It will appear to the right of the worksheet. If you don't have a shape already selected, the Selection Pane can be found in the ribbon under the Home tab, in the Find & Select dropdown menu

Microsoft Office Microsoft Excel VBA. 18 Comments 1 Solution 860 Views Last Modified: 2/27/2017. I'm trying to hide shapes depending on I15 cell selection. This is sort of an amalgamation between the code provided here What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange Excel VBA Hide Columns Hiding is a simple thing, but you need to understand the concept here. To hide the column using VBA, we need to determine which column we need to hide. To specify the column to be hidden, we need to use the RANGE object What This VBA Code Does This VBA code is a nifty little I created to solve the hassle of selecting each shape individually in order to group them. With this code, you can essentially select a range of cells and any shapes within that selected range will get automatically grouped together

The below examples loop through on all types of shapes. For Each Loop (on a sheet) ' ----- ' Purpose: Loop through all shapes on a sheet ' ----- Sub loopShapesSheet() Dim shp As Shape Dim sh As Worksheet Set sh = ThisWorkbook.Worksheets(Shape1) 'If there is any shape on the sheet If sh.Shapes.Count > 0 Then 'Loop through all the shapes on the sheet For Each shp In sh.Shapes 'Print to. When working with Excel, you may find yourself in situations where you may need to hide or unhide certain rows or columns using VBA. Consider, for example, the following situations (mentioned by Excel guru John Walkenbach in the Excel 2016 Bible) where knowing how to quickly and easily hide rows or columns with a macro can help you:. You've been working on a particular Excel workbook Learn how to hide multiple excel worksheets using a quick VBA snippet. Super easy!Get My Bestselling Excel VBA Courses:Excel VBA Essentials Course: https://b..

Hide Columns. There are several ways to refer to a column in VBA. First you can use the Columns Object: Columns (B:B).Hidden = True. or you can use the EntireColumn Property of the Range or Cells Objects: Range (B4).EntireColumn.Hidden = True. or. Cells (4,2).EntireColumn.Hidden = True Hide-UnHide Rows in Excel Worksheet using VBA - An Example. The following example will show you how to Hide and Unhide the rows in excel worksheet using VBA. We can Hide or Unhide the multiple rows at a time. In this example I am hiding and Unhiding Rows 5 to 8. Code: Sub sbHidingUnHideRows() 'To Hide Rows 5 to 8 Rows(5:8).EntireRow.Hidden. Programming Excel 2007 and Excel 2010 AutoShapes with VBA. With the release of Office 2007, Microsoft rewrote the drawing tools from the ground up. On the plus side, this meant new shapes, new styles, and the addition of SmartArt. On the downside, they didn't have time to incorporate AutoShape operations in their macro recorder prior to release I want my VBA program to hide some shapes and show others (in Visio 2010 Pro). I'm looking for something like the .Visible property in Visual Basic, but I haven't found it in the Help. · One of the first articles on my website dealt with the many different ways to hide shapes in Visio. Take a look here: The Hidden World of Visio Shapes I know that you.

How to hide or unhide a certain shape based on specified

There are multiple worksheets within this workbook along with 2 AutoShapes that I do not want to be visible in the view only copy. I know how to hide the worksheets that I do not want to visible using VBA but I still have 2 issues that I need help with: 1. How can I hide the 2 AutoShapes in the view only copy using VBA. Bot What This VBA Code Does. The following VBA code will provide you with a way to delete all shapes from your currently selected spreadsheet. You will also learn how to further manipulate this code to filter out certain shape types from deletion

For iX = 1 To 14. Me.Shapes.Range (CB340- & iX).Visible = Select340. Next iX. Application.ScreenUpdating = True. End Sub. Display More. Sorry for not clarifying... Select340 is a toggle button that (when pressed) unhides rows 298:317 as well as all the checkboxes associated with those rows Then I opened the VBA module for each of them and used the two drop-down boxes at the top of the VBA Editor window to select each event procedure for each of the two Form objects. In each of these new procedures, I added a Debug.Print Form <Event> or a Debug.Print Subform <Event> , as appropriate, and then I copied and pasted the event name. VBA conditional Formatting multiple Excel shapes Hi, I would like to conditional format the colour of multiple shapes in excel based on the value of corresponding cells. Example. Cell A1 = 95% Shape Colour = Green. Cell A2 = 91% Shape Colour = Yellow. Cell A2 = 85% Shape Colour = Red.

VBA code to hide a shape (Rectangle) MrExcel Message Boar

Select a button on the UserForm and set the Cancel property to True. When the UserForm is displayed, pressing the Esc key will trigger the button you applied the Cancel property to. Therefore Cancel can be assigned to a button with hide or unload. 100 Excel VBA Macros It is very easy to add text to shapes dynamically in Excel using VBA, provided you know the properties. VBA's Shape object provides a property called TextFrame, which gives access to the text of any shape. Let us see how you can use the VBA TextFrame property in your macro to add text to shapes dynamically How to delete Excel shapes (AutoShapes) using VBA. AutoShapes are stored in the Shapes collection under a worksheet object. This means that we can loop through Excel shapes in a worksheet and delete them. For Each shp In ActiveSheet.Shapes shp.Delete Next shp. To delete the AutoShapes from the whole workbook, we need to check every sheet Copy above VBA code. Press Alt + F11 to open the Visual Basic Editor. Double press with left mouse button on your workbook name (Locate a shape.xlsm) in the Project Explorer. Press with left mouse button on Insert on the menu. Press with left mouse button on Module to create a module in your workbook. Paste VBA code to code window, see. How to hide gridlines in multiple worksheets using Excel and VBA methods. METHOD 1. Hide gridlines in multiple worksheets using a ribbon option. EXCEL. Select worksheets > View tab > Show group > Uncheck Gridlines checkbox. 1. Select the worksheets in which to hide the gridlines. Note: in this example we are hiding the gridlines in Sheet 2 and 3

vba - How to Hide or Unhide Multiple Worksheets with a

How to show or hide all objects (pictures/charts/shapes

How to Hide or Show Objects in Excel - Free Excel Tutoria

Loop through all Chart Objects. If there are multiple ChartObjects on a page, we can loop through each: .Shapes.AddChart2.Chart 'Change chart title text cht.ChartTitle.Text = Bullet Chart with VBA 'Hide the legend cht.HasLegend = False 'Change chart type cht.ChartType = xlBarClustered 'Select Get our FREE VBA eBook of the 30 most. It's important to note that there is a space between 'Button' and '8' in the above macro. To access Form Controls on your sheet in VBA, you need to use the syntax: Activesheet.Shapes ( [Optional Object Name]).OLEFormat.Object. The above syntax will then let you access a Form Controls properties and methods #3 click Insert ->Module to create a new module. #4 paste the below VBA code into the code window. Then clicking Save button. Sub DeleteAllTextBoxes() ActiveSheet.Shapes.SelectAll Selection.Delete End Sub #5 back to the current worksheet, then run the above excel macro. Click Run button. You would notice that all text boxes are removed from your current worksheet That's the overall principle behind hiding sheets using VBA. Let's go over the basics. In normal Excel, a sheet is either Visible or it's Hidden. If you can see it at the bottom of the page, it's Visible, and you can right click on the sheet name, click Hide, and this will classify the sheet as a Hidden sheet

Excel. 1 Open MS Excel. 2 Create a blank workbook. 3 Go to Developer's tab > click on Visual Basic button or hit Alt + F11. 4 Go to Insert tab > click on Module or hit M. 5 Copy the VBA code from below. 6 Paste the code in the newly created module. 7 Go to Run tab > click on Run Sub/UserForm or hit F5. 8 That's it In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps: In the upper-left corner of the Excel window, click the Microsoft Office button. At the bottom of the menu, click Excel Options. Click Advanced from list of options on the left Excel-VBA: create named Range in row until end of cell content. vba,excel-vba,range. Sure you can use this snippet to find the last filled cell in a column and use that row number to set your range.name - just replace the A with whatever column you'd like

Show/Hide Group of shapes while keeping individual shape

VBA FOR EACH NEXT is a fixed loop that can loop through all the objects in a collection. In the For Each Next, you don't need to specify the count of iterations. Instead, you can specify a collection of objects, and it will be able to loop through all those objects one by one. For Example: If you want to loop through all the cells from a range 3. Excel Shapes. Apart from creating buttons from the Developer tab, Excel users can use Excel Shapes to create the buttons. The advantage of using Excel Shapes over Form Control buttons or ActiveX Control buttons is that shapes allow the most formatting and styling options. You can change button color, design, and font to make the buttons look. The Combo Box option can be used to store multiple dropdown criteria. The fact of the matter is: I want to use Combo Box to view the updation of reports, but I do not want to see the Combo Box while printing. Objects such as text boxes, shapes, and pictures all have a default setting of objects will print I believe that Excel is one of the most used programs in the business world. Probably, we spend more time only on Facebook, Instagram and YouTube these days. My mission is to share practical knowledge in Excel VBA which goes beyond knowing how to write a few lines of VBA code

Create and modify Powerpoint shapes with VBA | EasyTweaks

In our example, we want to hide the rows that do not contain the value 'In service' in column 3.But you can replace the value of ColNum number from 3 in line 4 to the column number containing your criteria values.; Close the VBA window. Note: If your dataset covers more than 19 rows, you can change the values of the StartRow and EndRow variables to your required row numbers To work with PowerPoint from Excel, you'll have to first add a PowerPoint library reference to your VBA application. 1) From the top menu in your VBA editor, choose Tools - References.It will open the References dialog box. 2) In the dialog box, find Microsoft PowerPoint 12.0 Object Library and click OK. Or any version, which is installed in your computer

To do this. Press. Move to the Tell me or Search field on the Ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File page and use Backstage view.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text. Excel VBA, Save Range/Cells as JPEG. In this article I will explain how you can use VBA for Excel to save a range of cells as a JPEG image. Basically what we do is the following: Create an empty chart in some sheet which is not used. Copy the cells with the required data as a picture. Paste the range onto the chart

Delete or Hide Objects/Controls on a workshee

Excel 2013 VBA - select multiple shapes. hindersaliva asked on 1/15/2015. Microsoft Excel. 5 Comments 3 Solutions 7627 Views Last Modified: 1/16/2015. I have a number of small rectangles on a sheet. I can iterate through the shapes that are positioned within a selected cell range ok In Excel 2016, Excel 2013, Excel 2010 and Excel 2007, go to the Home tab > Cells group, and click the Format Under Visibility, point to Hide & Unhide, and then click Unhide Sheet . Note. Excel's Unhide option only allows you to select one sheet at a time. To unhide multiple sheets, you will have to repeat the above steps for each worksheet. Hi, I am trying to copy some text from Word to excel (I need it compatible with Excel 2003). All is good but it copies into border and I would like to hide the the border line. Thanks in advance for any help. Lukas. Here is the code: Private Sub CommandButton1_Click () Dim MyWd As Object. Dim j As Integer To select all these objects simultaneously, just click on the F5 key, which will bring up the Go To dialog box. Then click on the Special button: Another dialog box will appear. From here, select Objects and click OK: Excel now has selected all the objects on your worksheet: At this point, just click your Delete key, and all the check boxes are. 1. August 21, 2018 - 3:51 am. Hello, I have couple worksheets and the first sheet is the Checklist (main sheet). I've created hyperlinks to the rest of the sheets from this main worksheet, I want to hide all of the sheets except the Checklist (main sheet) in which is easy to do; however, the hyperlink will not work if the sheets are hidden

How to Unhide and Rehide Multiple Sheets in Excel - Excel

Excel 2016 VBA - Show/Hide multiple shape groups [closed

0:00. 0:00 / 10:42. Live. •. ⇨ Generally ,the shapes in the worksheet are moved with Vba codes and loops. ⇨ Let's review an VBA animation sample : This Excel animation includes an .wav file to play audio during action Excel VBA to hide Group Outline in Excel As mentioned above, this option is not directly applicable to Whole workbook or Excel as an application. Therefore, you would not find any property to hide or show Group outline in any of these Objects - Application or Workbook. Inserting a Shape. To insert a shape simply click on the shape you want from the drop down menu. Excel will automatically choose the default colour and style. A new Format tab will appear in the ribbon when the shape is selected. This is where you can change the colour, style, fill, outline, effects. Right-clicking on the shape opens up a. - Multiple spreadsheets - Correct your mistakes - Find Text - Replace text - Office 2013 vs 365; Excel Made Easy. Vba assign macro to shape in Excel For example, I have a macro GenerateReport in my WorkBook. I want to assign a macro to Shape Rectangle 1 using VBA. To do it in Excel, here is the answer Adding multiple objects to multiple sheets. Define a name of each sheet in Excel (instead of just using Sheet1, Sheet2, etc.) Exporting either the data of an object or exporting the object/chart as an image. Therefore we first have to create an export definition by using a multidimensional array in VBScript: Dim aryExport (0,3

Working with multiple shapes - Wise Ow

Shape Properties. Read-only. An object accessing the adjustments for a shape. Set/Get the alternate text to appear if the image is not loaded. Used with a web page. Set/Get an MsoBackgroundStyleIndex constant representing the background style. Property used for compatibility with other drawing packages only Here are the steps to hide a worksheet so that it can not be unhidden: Right-click on any of the worksheet tabs. Click on View Code. In the VB Editor, in the project explorer in VB Editor, select the worksheet you want to hide. With the sheet selected, click on the Properties icon in the toolbar (or use the keyboard shortcut F4)

Shapes object (Excel) Microsoft Doc

To create a shape in worksheet and format by using VBA Excel. Approach. Here we have added a rectangular shape in sheet 1, then we have modified the properties of the shape object. What this code does. Add a shape on Excel worksheet; Rename a shape; Position a shape on worksheet; Change height and width of a shape; Fill color in shape #1 - What makes this workbook special? » Back to contents. Sometimes the best ideas come out of necessity. Kamal Bharakhda is a VBA developer and report automation specialist who works with Launch Excel. He recently helped a client who needed an interactive map of Algeria in Excel Below, we can see a shape configured to hide all geometry and text, according to the value of User.isHidden. Formatting. Of course, if you need to hide an entire shape, it seems like it makes sense to just use formatting. Your natural inclination might be to use the color cells to hide our shape: Fill.Format. FillForegnd; Fill Format. FillBkgnd. Introduction. This VBA Guide will teach you everything you ever wanted to know about handling Excel Form Control Option Buttons using VBA. By Form Control option buttons, also known as radio buttons, I mean this fellow located under Form Controls on the Developer Tab > Insert menu:. Form Control Option Butto In VBA, you have two collections that can be a bit confusing at times. In a workbook, you can have worksheets and as well as chart sheets. The example below has three worksheets and one chart sheet. In Excel VBA: The 'Worksheets' collection would refer to the collection of all the worksheet objects in a workbook

As with so many things in Excel there are many ways to do the same thing. The following draws on the learnings from the Heat Map in Excel. This method allows you to toggle the colours of a shape in Excel. The VBA procedure does this by changing the value in F9 from 1 to 2. The following is the VBA to achieve the task UserForms in Excel VBA UserForm is a customized user interface (viz. custom dialog box), developed in VBA. It enables a user to interact, using a Form, in an organized and logical manner, to make data entry or for data retrieval with an Excel worksheet or to run a VBA application

Hide multiple Excel worksheets Excel, VB

Next, start creating your first view by hiding applicable rows/columns. A little-known side note here, a shortcut to hide columns in Excel is ctrl + 0 and the shortcut to hide rows is ctrl + 9. It will hide whichever row/column is related to whatever selection you define. This saves a lot of time when creating these views Using ActiveX Controls on a Worksheet have been illustrated in detail, in the separate section of Excel VBA: ActiveX Controls, Form Controls & AutoShapes on a Worksheet. Create a UserForm Open Visual Basic Editor (VBE) in Excel by pressing ALT+F11 in an open workbook, or right-click on the worksheet tab at the bottom, and select View Code How to Use this VBA Code. To use this code, you need to add this to a module in the Visual Basic Editor in Excel, and then run this code from there. Below are the steps to add this VBA code to unhide rows to a module in VB Editor: Right-click on any of the worksheet tabs; Click on View Code. This will open the VB Editor windo

ExcelMadeEasy: Automatic image alignment in Excel

Shapes.Range property (Excel) Microsoft Doc

To Add or Insert Multiple objects from a folder in Microsoft Excel, you need to follow the steps below: Create the object of FileSystemObject (Link) Create Folder object using FileSystemObject and GetFolder (link) method and count the number of files. Get the files Object. Run the Loop for each files in folder One way to load data into an Excel worksheet is to simply use Get Data option from Data tab. But it's a manual process. In this article, let us look at another way to load data using VBA with ADO as the interface. ADO stands for ActiveX Data Objects, the reason for using ADO in Continue reading Accessing multiple data sources using ADO and VBA in Excel

How to Hide Multiple Sheets using VBA in Microsoft Excel 201

Check Excel VBA help and you will find the syntax is . Select method as it applies to the Chart, Charts, Shape, ShapeRange, Sheets, Worksheet, and Worksheets objects. Selects the object. expression.Select(Replace) expression Required. An expression that returns one of the above objects. Replace Optional Variant. The object to replace Project Explorer: This contains all the sheets in the workbook and the workbook itself.It has a Modules folder that stores all the VBA code. When you record macros, they're included in a module. To add a new, empty module, click on VBA Project (Book1) -> RightClick -> Insert -> Module.. Properties Window: It contains all the properties of an object like font, color, height, width, etc. VBA Useful Codes. Add a worksheet at a specified position using VBA. Add or Insert New sheet with specified name. Add st,nd,rd and th to date. Add/Insert New Columns in Excel using VBA. Apply Borders to Excel Sheet. Attach active workbook in an Email. Autofit Column Rows in Excel VBA 7. Adding a New Series to the chart identified by the object variable myChart, drawing the data from the range C4:K4 on the active worksheet in the active workbook, using rows: 8. 9. Creating a New Series, use the NewSeries method with the SeriesCollection collection. 10

Excel VBA Userform. Userform in VBA are customized user-defined forms which are made to take input from a user in the format of a form, it has different sets of controls to add such as text boxes, checkboxes labels, etc to guide a user to input a value and it stores the value in the worksheet, every part of user form has a unique code with it.. Userform is an object within the Excel interface. VBA copy rename worksheet in Excel. To do it in Excel, here is the answer: a) Line 3 - ThisWorkbook.Sheets.Count represents the last sheet. ActiveSheet is copied and moved to end of the workbook. b) Line 4 - Since by default after copying sheet, the copied sheet is activated, ActiveSheet object could be used to rename the copied WorkSheet VBA Code for Embedding Picture in Excel Sheet [Method 2] Using .Shapes.AddPicture() method, you can insert a picture in Active sheet. This method overcome the challenges of above method. This allows user to Embed the picture with the Excel Workbook itself Excel insert multiple file objects (VBA) Application.GetFileName Method has an argument called MultiSelect, which allows users to select multiple files and return an array of file names. I modify the above procedure a little bit, if you have selected multiple files, each object is inserted on the right hand side of the starting cell Data input really allows you to create very powerful applications using Excel VBA. To learn to unlock the true power of Excel, take a look at the Visual Basic for Excel - Microsoft VBA Excel Tutorial. This certified course will show you how to create macros, functions and procedures that will take your use of Excel to the next level To unhide all Sheets in Excel we must revert to VBA as there is no other way to select multiple worksheets using the built in Excel Unhide window. Again let us open the Visual Basic Editor by using the Excel Keyboard shortcut ALT + F11