How to unhide 'Very Hidden' Worksheet
44
I was messing around in the sheet settings and somehow managed to make a sheet 'very hidden', but I cannot seem to make it visible again. How can I make it visible?
I am using Excel 2010.
microsoft-excel
edited Sep 28 '17 at 15:53
TylerH
351317
add a comment |
44
I was messing around in the sheet settings and somehow managed to make a sheet 'very hidden', but I cannot seem to make it visible again. How can I make it visible?
I am using Excel 2010.
microsoft-excel
edited Sep 28 '17 at 15:53
TylerH
351317
add a comment |
44
44
44
4
I was messing around in the sheet settings and somehow managed to make a sheet 'very hidden', but I cannot seem to make it visible again. How can I make it visible?
I am using Excel 2010.
microsoft-excel
edited Sep 28 '17 at 15:53
TylerH
351317
I was messing around in the sheet settings and somehow managed to make a sheet 'very hidden', but I cannot seem to make it visible again. How can I make it visible?
I am using Excel 2010.
microsoft-excel
microsoft-excel
edited Sep 28 '17 at 15:53
TylerH
351317
edited Sep 28 '17 at 15:53
TylerH
351317
edited Sep 28 '17 at 15:53
TylerH
351317
edited Sep 28 '17 at 15:53
TylerH
351317
edited Sep 28 '17 at 15:53
TylerH
351317
351317
asked Sep 28 '17 at 10:54
user775305
add a comment |
add a comment |
4 Answers
4
active
oldest
votes
40
One option is to do it with VBA
Try out the below:
Sub UnHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = True
Next
End Sub
This will show up ALL sheets that are hidden, or very hidden
answered Sep 28 '17 at 10:55
PeterH
3,44332246
5
Yeah,Very Hiddencan only be unhidden with VBA.
– BruceWayne
Sep 28 '17 at 13:30
3
No, that's wrong. See my reply.
– NiklasJ
Sep 28 '17 at 15:23
9
@NiklasJ The code is not wrong; this will work to set them to visible.
– TylerH
Sep 28 '17 at 15:40
8
@NiklasJ - this code will unhide all sheets in one go, your method will unhide one sheet at a time. Neither is wrong, both are correct. This is the method I would have chosen because I didn't even know your method existed! TIL!
– FreeMan
Sep 28 '17 at 16:48
11
@TylerH I think Nilklas was referring to the implicit statement that you must use code to unhide the cells. His answer does not rely on code.
– jpaugh
Sep 29 '17 at 3:35
|
show 3 more comments
58
You do it like this:
- Open VBA editor (Alt+F11)
- Open the VBAProject corresponding to your file.
- Open the "Microsoft Excel-objects" folder
- Select the Sheet you've hidden.
- Go to the properties (press F4)
- Change the property "Visible" to xlSheetVisible instead of xlSheetVeryHidden
edited Oct 7 '17 at 3:31
Scott
15.5k113889
answered Sep 28 '17 at 15:22
NiklasJ
64133
add a comment |
14
In VBA editor, go to the sheet properties and change the below property
answered Sep 29 '17 at 10:43
Scorpion99
9211029
3
this is the same method as NiklasJ above ?
– user775305
Sep 29 '17 at 11:34
2
I just noticed, yes it is the same but with picture.
– Scorpion99
Sep 29 '17 at 11:40
You should have edited @NiklasJ's answer and added the picture...
– Twisty Impersonator
Sep 26 at 12:44
I accidentally hid the only sheet in a workbook! I tried the above, saved the spreadsheet, and tried to open it, and it (entire workbook) is not visible. Any ideas?
– Mark Stewart
Nov 16 at 16:17
Ha! I had another spreadsheet open, and that is why I couldn't see anything. I closed all Excel workbooks, then opened it, nothing was visible but the "View" toolbar had an unhide option enabled!
– Mark Stewart
Nov 16 at 16:23
add a comment |
1
To keep them hidden, but visible in the options menu (UnHide..), use the same code but with this..
Sub StillHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = xlSheetHidden <-- change from Visible to this.
Next
End Sub
That way the tabs are not all of a suddenly showing to the user. They are still "hidden".
answered Dec 13 at 6:44
Fandango68
1133
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1254447%2fhow-to-unhide-very-hidden-worksheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
40
One option is to do it with VBA
Try out the below:
Sub UnHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = True
Next
End Sub
This will show up ALL sheets that are hidden, or very hidden
answered Sep 28 '17 at 10:55
PeterH
3,44332246
5
Yeah,Very Hiddencan only be unhidden with VBA.
– BruceWayne
Sep 28 '17 at 13:30
3
No, that's wrong. See my reply.
– NiklasJ
Sep 28 '17 at 15:23
9
@NiklasJ The code is not wrong; this will work to set them to visible.
– TylerH
Sep 28 '17 at 15:40
8
@NiklasJ - this code will unhide all sheets in one go, your method will unhide one sheet at a time. Neither is wrong, both are correct. This is the method I would have chosen because I didn't even know your method existed! TIL!
– FreeMan
Sep 28 '17 at 16:48
11
@TylerH I think Nilklas was referring to the implicit statement that you must use code to unhide the cells. His answer does not rely on code.
– jpaugh
Sep 29 '17 at 3:35
|
show 3 more comments
40
One option is to do it with VBA
Try out the below:
Sub UnHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = True
Next
End Sub
This will show up ALL sheets that are hidden, or very hidden
answered Sep 28 '17 at 10:55
PeterH
3,44332246
5
Yeah,Very Hiddencan only be unhidden with VBA.
– BruceWayne
Sep 28 '17 at 13:30
3
No, that's wrong. See my reply.
– NiklasJ
Sep 28 '17 at 15:23
9
@NiklasJ The code is not wrong; this will work to set them to visible.
– TylerH
Sep 28 '17 at 15:40
8
@NiklasJ - this code will unhide all sheets in one go, your method will unhide one sheet at a time. Neither is wrong, both are correct. This is the method I would have chosen because I didn't even know your method existed! TIL!
– FreeMan
Sep 28 '17 at 16:48
11
@TylerH I think Nilklas was referring to the implicit statement that you must use code to unhide the cells. His answer does not rely on code.
– jpaugh
Sep 29 '17 at 3:35
|
show 3 more comments
40
40
40
One option is to do it with VBA
Try out the below:
Sub UnHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = True
Next
End Sub
This will show up ALL sheets that are hidden, or very hidden
answered Sep 28 '17 at 10:55
PeterH
3,44332246
One option is to do it with VBA
Try out the below:
Sub UnHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = True
Next
End Sub
This will show up ALL sheets that are hidden, or very hidden
answered Sep 28 '17 at 10:55
PeterH
3,44332246
edited Apr 23 at 14:53
answered Sep 28 '17 at 10:55
PeterH
3,44332246
answered Sep 28 '17 at 10:55
PeterH
3,44332246
answered Sep 28 '17 at 10:55
PeterH
3,44332246
3,44332246
5
Yeah,Very Hiddencan only be unhidden with VBA.
– BruceWayne
Sep 28 '17 at 13:30
3
No, that's wrong. See my reply.
– NiklasJ
Sep 28 '17 at 15:23
9
@NiklasJ The code is not wrong; this will work to set them to visible.
– TylerH
Sep 28 '17 at 15:40
8
@NiklasJ - this code will unhide all sheets in one go, your method will unhide one sheet at a time. Neither is wrong, both are correct. This is the method I would have chosen because I didn't even know your method existed! TIL!
– FreeMan
Sep 28 '17 at 16:48
11
@TylerH I think Nilklas was referring to the implicit statement that you must use code to unhide the cells. His answer does not rely on code.
– jpaugh
Sep 29 '17 at 3:35
|
show 3 more comments
5
Yeah,Very Hiddencan only be unhidden with VBA.
– BruceWayne
Sep 28 '17 at 13:30
3
No, that's wrong. See my reply.
– NiklasJ
Sep 28 '17 at 15:23
9
@NiklasJ The code is not wrong; this will work to set them to visible.
– TylerH
Sep 28 '17 at 15:40
8
@NiklasJ - this code will unhide all sheets in one go, your method will unhide one sheet at a time. Neither is wrong, both are correct. This is the method I would have chosen because I didn't even know your method existed! TIL!
– FreeMan
Sep 28 '17 at 16:48
11
@TylerH I think Nilklas was referring to the implicit statement that you must use code to unhide the cells. His answer does not rely on code.
– jpaugh
Sep 29 '17 at 3:35
5
5
Yeah,
Very Hidden can only be unhidden with VBA.– BruceWayne
Sep 28 '17 at 13:30
Yeah,
Very Hidden can only be unhidden with VBA.– BruceWayne
Sep 28 '17 at 13:30
3
3
No, that's wrong. See my reply.
– NiklasJ
Sep 28 '17 at 15:23
No, that's wrong. See my reply.
– NiklasJ
Sep 28 '17 at 15:23
9
9
@NiklasJ The code is not wrong; this will work to set them to visible.
– TylerH
Sep 28 '17 at 15:40
@NiklasJ The code is not wrong; this will work to set them to visible.
– TylerH
Sep 28 '17 at 15:40
8
8
@NiklasJ - this code will unhide all sheets in one go, your method will unhide one sheet at a time. Neither is wrong, both are correct. This is the method I would have chosen because I didn't even know your method existed! TIL!
– FreeMan
Sep 28 '17 at 16:48
@NiklasJ - this code will unhide all sheets in one go, your method will unhide one sheet at a time. Neither is wrong, both are correct. This is the method I would have chosen because I didn't even know your method existed! TIL!
– FreeMan
Sep 28 '17 at 16:48
11
11
@TylerH I think Nilklas was referring to the implicit statement that you must use code to unhide the cells. His answer does not rely on code.
– jpaugh
Sep 29 '17 at 3:35
@TylerH I think Nilklas was referring to the implicit statement that you must use code to unhide the cells. His answer does not rely on code.
– jpaugh
Sep 29 '17 at 3:35
|
show 3 more comments
58
You do it like this:
- Open VBA editor (Alt+F11)
- Open the VBAProject corresponding to your file.
- Open the "Microsoft Excel-objects" folder
- Select the Sheet you've hidden.
- Go to the properties (press F4)
- Change the property "Visible" to xlSheetVisible instead of xlSheetVeryHidden
edited Oct 7 '17 at 3:31
Scott
15.5k113889
answered Sep 28 '17 at 15:22
NiklasJ
64133
add a comment |
58
You do it like this:
- Open VBA editor (Alt+F11)
- Open the VBAProject corresponding to your file.
- Open the "Microsoft Excel-objects" folder
- Select the Sheet you've hidden.
- Go to the properties (press F4)
- Change the property "Visible" to xlSheetVisible instead of xlSheetVeryHidden
edited Oct 7 '17 at 3:31
Scott
15.5k113889
answered Sep 28 '17 at 15:22
NiklasJ
64133
add a comment |
58
58
58
You do it like this:
- Open VBA editor (Alt+F11)
- Open the VBAProject corresponding to your file.
- Open the "Microsoft Excel-objects" folder
- Select the Sheet you've hidden.
- Go to the properties (press F4)
- Change the property "Visible" to xlSheetVisible instead of xlSheetVeryHidden
edited Oct 7 '17 at 3:31
Scott
15.5k113889
answered Sep 28 '17 at 15:22
NiklasJ
64133
You do it like this:
- Open VBA editor (Alt+F11)
- Open the VBAProject corresponding to your file.
- Open the "Microsoft Excel-objects" folder
- Select the Sheet you've hidden.
- Go to the properties (press F4)
- Change the property "Visible" to xlSheetVisible instead of xlSheetVeryHidden
edited Oct 7 '17 at 3:31
Scott
15.5k113889
answered Sep 28 '17 at 15:22
NiklasJ
64133
edited Oct 7 '17 at 3:31
Scott
15.5k113889
edited Oct 7 '17 at 3:31
Scott
15.5k113889
edited Oct 7 '17 at 3:31
Scott
15.5k113889
15.5k113889
answered Sep 28 '17 at 15:22
NiklasJ
64133
answered Sep 28 '17 at 15:22
NiklasJ
64133
answered Sep 28 '17 at 15:22
NiklasJ
64133
64133
add a comment |
add a comment |
14
In VBA editor, go to the sheet properties and change the below property
answered Sep 29 '17 at 10:43
Scorpion99
9211029
3
this is the same method as NiklasJ above ?
– user775305
Sep 29 '17 at 11:34
2
I just noticed, yes it is the same but with picture.
– Scorpion99
Sep 29 '17 at 11:40
You should have edited @NiklasJ's answer and added the picture...
– Twisty Impersonator
Sep 26 at 12:44
I accidentally hid the only sheet in a workbook! I tried the above, saved the spreadsheet, and tried to open it, and it (entire workbook) is not visible. Any ideas?
– Mark Stewart
Nov 16 at 16:17
Ha! I had another spreadsheet open, and that is why I couldn't see anything. I closed all Excel workbooks, then opened it, nothing was visible but the "View" toolbar had an unhide option enabled!
– Mark Stewart
Nov 16 at 16:23
add a comment |
14
In VBA editor, go to the sheet properties and change the below property
answered Sep 29 '17 at 10:43
Scorpion99
9211029
3
this is the same method as NiklasJ above ?
– user775305
Sep 29 '17 at 11:34
2
I just noticed, yes it is the same but with picture.
– Scorpion99
Sep 29 '17 at 11:40
You should have edited @NiklasJ's answer and added the picture...
– Twisty Impersonator
Sep 26 at 12:44
I accidentally hid the only sheet in a workbook! I tried the above, saved the spreadsheet, and tried to open it, and it (entire workbook) is not visible. Any ideas?
– Mark Stewart
Nov 16 at 16:17
Ha! I had another spreadsheet open, and that is why I couldn't see anything. I closed all Excel workbooks, then opened it, nothing was visible but the "View" toolbar had an unhide option enabled!
– Mark Stewart
Nov 16 at 16:23
add a comment |
14
14
14
In VBA editor, go to the sheet properties and change the below property
answered Sep 29 '17 at 10:43
Scorpion99
9211029
In VBA editor, go to the sheet properties and change the below property
answered Sep 29 '17 at 10:43
Scorpion99
9211029
answered Sep 29 '17 at 10:43
Scorpion99
9211029
answered Sep 29 '17 at 10:43
Scorpion99
9211029
answered Sep 29 '17 at 10:43
Scorpion99
9211029
9211029
3
this is the same method as NiklasJ above ?
– user775305
Sep 29 '17 at 11:34
2
I just noticed, yes it is the same but with picture.
– Scorpion99
Sep 29 '17 at 11:40
You should have edited @NiklasJ's answer and added the picture...
– Twisty Impersonator
Sep 26 at 12:44
I accidentally hid the only sheet in a workbook! I tried the above, saved the spreadsheet, and tried to open it, and it (entire workbook) is not visible. Any ideas?
– Mark Stewart
Nov 16 at 16:17
Ha! I had another spreadsheet open, and that is why I couldn't see anything. I closed all Excel workbooks, then opened it, nothing was visible but the "View" toolbar had an unhide option enabled!
– Mark Stewart
Nov 16 at 16:23
add a comment |
3
this is the same method as NiklasJ above ?
– user775305
Sep 29 '17 at 11:34
2
I just noticed, yes it is the same but with picture.
– Scorpion99
Sep 29 '17 at 11:40
You should have edited @NiklasJ's answer and added the picture...
– Twisty Impersonator
Sep 26 at 12:44
I accidentally hid the only sheet in a workbook! I tried the above, saved the spreadsheet, and tried to open it, and it (entire workbook) is not visible. Any ideas?
– Mark Stewart
Nov 16 at 16:17
Ha! I had another spreadsheet open, and that is why I couldn't see anything. I closed all Excel workbooks, then opened it, nothing was visible but the "View" toolbar had an unhide option enabled!
– Mark Stewart
Nov 16 at 16:23
3
3
this is the same method as NiklasJ above ?
– user775305
Sep 29 '17 at 11:34
this is the same method as NiklasJ above ?
– user775305
Sep 29 '17 at 11:34
2
2
I just noticed, yes it is the same but with picture.
– Scorpion99
Sep 29 '17 at 11:40
I just noticed, yes it is the same but with picture.
– Scorpion99
Sep 29 '17 at 11:40
You should have edited @NiklasJ's answer and added the picture...
– Twisty Impersonator
Sep 26 at 12:44
You should have edited @NiklasJ's answer and added the picture...
– Twisty Impersonator
Sep 26 at 12:44
I accidentally hid the only sheet in a workbook! I tried the above, saved the spreadsheet, and tried to open it, and it (entire workbook) is not visible. Any ideas?
– Mark Stewart
Nov 16 at 16:17
I accidentally hid the only sheet in a workbook! I tried the above, saved the spreadsheet, and tried to open it, and it (entire workbook) is not visible. Any ideas?
– Mark Stewart
Nov 16 at 16:17
Ha! I had another spreadsheet open, and that is why I couldn't see anything. I closed all Excel workbooks, then opened it, nothing was visible but the "View" toolbar had an unhide option enabled!
– Mark Stewart
Nov 16 at 16:23
Ha! I had another spreadsheet open, and that is why I couldn't see anything. I closed all Excel workbooks, then opened it, nothing was visible but the "View" toolbar had an unhide option enabled!
– Mark Stewart
Nov 16 at 16:23
add a comment |
1
To keep them hidden, but visible in the options menu (UnHide..), use the same code but with this..
Sub StillHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = xlSheetHidden <-- change from Visible to this.
Next
End Sub
That way the tabs are not all of a suddenly showing to the user. They are still "hidden".
answered Dec 13 at 6:44
Fandango68
1133
add a comment |
1
To keep them hidden, but visible in the options menu (UnHide..), use the same code but with this..
Sub StillHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = xlSheetHidden <-- change from Visible to this.
Next
End Sub
That way the tabs are not all of a suddenly showing to the user. They are still "hidden".
answered Dec 13 at 6:44
Fandango68
1133
add a comment |
1
1
1
To keep them hidden, but visible in the options menu (UnHide..), use the same code but with this..
Sub StillHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = xlSheetHidden <-- change from Visible to this.
Next
End Sub
That way the tabs are not all of a suddenly showing to the user. They are still "hidden".
answered Dec 13 at 6:44
Fandango68
1133
To keep them hidden, but visible in the options menu (UnHide..), use the same code but with this..
Sub StillHide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = xlSheetHidden <-- change from Visible to this.
Next
End Sub
That way the tabs are not all of a suddenly showing to the user. They are still "hidden".
answered Dec 13 at 6:44
Fandango68
1133
answered Dec 13 at 6:44
Fandango68
1133
answered Dec 13 at 6:44
Fandango68
1133
answered Dec 13 at 6:44
Fandango68
1133
1133
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1254447%2fhow-to-unhide-very-hidden-worksheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
