If you are looking for ways to unhide other elements in Excel, such as rows, columns, or sheet tabs, then this guide will show you the steps to follow to unhide almost anything in your workbook. If that is not your preferred functionality, then you will need to return to the menu in Step 3 from within the Personal workbook, then select the Hide option instead. Note that in the specific case of the Personal macro workbook that we unhid in this guide, that workbook will automatically open each time that you start Excel 2010. Step 4: Select the workbook that you want to unhide, then click the OK button. Step 3: Click the Unhide button in the Window section of the Office ribbon at the top of the window. Step 2: Click the View tab at the top of the window. These steps are very similar in other versions of Excel that use the Office ribbon, such as Excel 2007 and Excel 2013.
![unhide personal macro workbook excel 2016 unhide personal macro workbook excel 2016](https://yarnthen.github.io/yarnthencohosking/images/unhidemacrowb.jpg)
The worksheet goes away, and you should immediately exit Excel. To solve the problem, just start Excel and when the Personal.xlsb file is visible, display the View tab of the ribbon and click Hide in the Window group.
#Unhide personal macro workbook excel 2016 how to
The steps in this article will show you how to unhide an entire workbook that has been hidden in Microsoft Excel 2010. Normally the worksheet is hidden, unless it has been specifically unhidden and Excel saved.
![unhide personal macro workbook excel 2016 unhide personal macro workbook excel 2016](https://i3.ytimg.com/vi/HC6M2xNUdl0/hqdefault.jpg)
So if you are looking for a workbook that should be open, such as the Personal Macro workbook, then you can follow our tutorial below and learn how to unhide it. Whether this means certain rows or columns, or even entire worksheets and workbooks, almost every potentially unwanted item in Excel 2010 can be hidden.īut it is often a somewhat different process to unhide items that you have hidden, and this can be amplified if a different person on your computer was the one doing the hiding. One way to alleviate some of this confusion is to hide some of the elements that you do not need. Microsoft Excel windows can easily become cluttered, which can make it difficult to concentrate on the task you are trying to complete.