Where is View, Window, Unhide in Excel 365? I am trying to unhide my personal.xlsb but can't find unhide in any of the menus. I am, however, able to add Window Unhide to the Quick Access Toolbar and then unhide the sheet. I think this is the first time I am trying to edit a macro since I switched to 365.
TIA
Unhide Personal.xlsb in 365
-
- 2StarLounger
- Posts: 184
- Joined: 08 Feb 2010, 23:37
- Location: Howell, Michigan USA
Unhide Personal.xlsb in 365
Sherry
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Unhide Personal.xlsb in 365
You don't have to unhide Personal.xlsb if you want to edit a macro in your personal macro workbook.
Simply activate the Visual Basic Editor by pressing Alt+F11 or by clicking Visual Basic on the Developer tab of the ribbon.
If necessary, expand Personal (PERSONAL.XLSB) in the Project Explorer pane on the left hand side, then expand Modules, and double-click on a module to view/edit the code in that module.
Simply activate the Visual Basic Editor by pressing Alt+F11 or by clicking Visual Basic on the Developer tab of the ribbon.
If necessary, expand Personal (PERSONAL.XLSB) in the Project Explorer pane on the left hand side, then expand Modules, and double-click on a module to view/edit the code in that module.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 184
- Joined: 08 Feb 2010, 23:37
- Location: Howell, Michigan USA
Re: Unhide Personal.xlsb in 365
Thanks Hans. I'm wondering why when I select Macros on the View Ribbon and then try to edit a macro in personal.xlsb it says I can't change a hidden workbook and to unhide the workbook using the unhide command. But there is no unhide command on the View ribbon.
Sherry
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Unhide Personal.xlsb in 365
That is a strange quirk in Excel...
Unhide is in the Window group of the View tab of the ribbon. If your Excel window is narrow, the Window group looks like this:
To see, click the Window drop-down:
If the Excel window is wider, the Widow group is expanded. Unhide becomes a separate button:
If the window is even wider, you'll see the caption:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 184
- Joined: 08 Feb 2010, 23:37
- Location: Howell, Michigan USA
Re: Unhide Personal.xlsb in 365
This is what my Viewmenu looks like?
[img]C:\Users\sherr\Desktop\window.png[/img]
[img]C:\Users\sherr\Desktop\window.png[/img]
You do not have the required permissions to view the files attached to this post.
Sherry
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Unhide Personal.xlsb in 365
Thanks. This is the Unhide button:
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 184
- Joined: 08 Feb 2010, 23:37
- Location: Howell, Michigan USA
Re: Unhide Personal.xlsb in 365
Well, Duh! But why don't I see the split and unhide? When I click that Window button, all that appears is unhide.
Sherry
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Unhide Personal.xlsb in 365
If you make the Excel window wider (if that is possible on your screen), you'll see the captions Split, Hide and Unhide - see the next to last and last screenshots that I posted above.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 184
- Joined: 08 Feb 2010, 23:37
- Location: Howell, Michigan USA
Re: Unhide Personal.xlsb in 365
Got it! My screen is only 14" so I will just add them to the Quick Access Toolbar.
Thanks Hans,
Thanks Hans,
Sherry
-
- 5StarLounger
- Posts: 1106
- Joined: 21 Jan 2011, 16:51
- Location: Florida
Re: Unhide Personal.xlsb in 365
One of many reasons that nearly 20 years later I still loath the Ribbon interface. Random things hidden because the interface decides to and you don't have any control over it.
PJ in (usually sunny) FL