Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden Tabs in a Workbook
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden Tabs in a Workbook
If the workbook's structure isn't protected, maybe you can run this macro. Just
put it in a different workbook's project. It uses the active workbook, so make sure you activate the problem workbook before hitting alt-f8 and running this code. Option Explicit Sub testme() dim sh as object for each sh in activeworkbook.sheets sh.visible = xlsheetvisible next sh end sub 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden Tabs in a Workbook
Forgive me, but we hardly use VB, Scripts or Marcos where work. They tend to
just screw things up things. So where would I put this code...assume I am a complete dummy...lol Which for scripts etc. I am. Thanks "ShaneDevenshire" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden Tabs in a Workbook
Never mind....I figured it out. The only thing is that the =INFO states it
should be 20 tabs, and I only get 14. It looks like it is all there, but I am not sure. "ShaneDevenshire" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden Tabs in a Workbook
Is this a real old workbook? Maybe created in xl95?
I'm not sure if I remember correctly, but it this was created in xl95, then all your macros were created in macro sheets--not VBE modules. I think that excel is counting those macro sheets (now converted to modules) as sheets. Danob wrote: Never mind....I figured it out. The only thing is that the =INFO states it should be 20 tabs, and I only get 14. It looks like it is all there, but I am not sure. "ShaneDevenshire" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subs and hidden tabs | Excel Discussion (Misc queries) | |||
Tabs hidden | Excel Discussion (Misc queries) | |||
Tabs in my workbook are hidden | Excel Discussion (Misc queries) | |||
Hidden tabs | Excel Discussion (Misc queries) | |||
Hidden tabs | Excel Discussion (Misc queries) |