Unable to unhide a hidden sheet

S

stanleykobeblue

New Member
Joined
Jan 4, 2005
Messages
25
I have a workbook that I have unprotected (all - workbook & worksheets). However, I have a sheet that I know is there (because I created it) but I cannot unhide. I know it is there because in the Name Manager, it points to it. Any idea how I can unhide it?
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Sort by date Sort by votes
Go into the VBA editor (Press Alt+F11), Make sure the proerties window is shown (Press F4 if it isn't), click on the sheet you wish to unhide, and at the very bottom of the properties window, you can choose its visibility.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Unprotect Sheet code runs, but doesn't unprotect sheet
Replies
3
Views
106
RockandGrohl
R
J
  • Question
Hide or Unhide a "Commandbutton" on a worksheet using VBA code
Replies
5
Views
82
Akuini
Akuini
E
  • Question
Unhide the left column of VBA on Mac
2
Replies
17
Views
291
excellence
E
C
  • Solved
VBA to unhide all sheets but return to active sheet
Replies
8
Views
92
colzre
C
M
  • Question
Very hidden sheet and unhide in VBA
Replies
1
Views
221
ExcelToDAX
E

Forum statistics

Threads
1,214,520
Messages
6,120,007
Members
448,935
Latest member
ijat

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top