View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Hidden Tabs in a Workbook

Hi,

Very simple:

Add the following code to a different workbook:

Sub makevisible()
For Each sh In Worksheets
sh.Visible = True
Next sh
End Sub

then move to the workbook with hidden sheet and run it.

--
Thanks,
Shane Devenshire


"Danob" wrote:

There are several hidden tabs in the workbook I am attempting to salvage from
a crash that I cannot access. I can 12 tabs, and know there are 17 based on
the =INFO("numfile") expression I added to one of the open tabs. The problem
is that the file has no passwords on it, and neither does the workbook. When
I try to use the VBA editor in explorer mode I am getting asked for a
password which I do not know. I know the name of one of the tabs as it is in
a formula, and data is getting pulled from the tab. I just cannot get to the
tabs to change the information let alone see if it is all correct.

Is there something like a password breaker similar to the the one on
www.straxx.com or am I up the creek on this?
Thanks