Invisible sheets
 

Hi.

I have received an excel file with vba and it has the code which prevents
the file to display most sheets. Is there any way (user level) other than
deleting or commenting that section of code to display the sheets?

Thank you.
--
Emil

Invisible sheets
 

hi Emil,
that depends on how the sheets are hidden (hidden or veryhidden).
if only hidden, try Format/Sheet/Unhide
if veryhidden, you can open the VBA editor and change the visible-
option of a sheet from veryhidden to visible.

bye
stefan

On 20 Mai, 08:08, emilh wrote:
Hi.

I have received an excel file with vba and it has the code which prevents
the file to display most sheets. Is there any way (user level) other than
deleting or commenting that section of code to display the sheets?

Thank you.
--
Emil

Invisible sheets
 

Thanks stefan.

it's 'xlSheetVeryHidden'

it seems that the only way is change the code each time i want to access the
data in those sheets?

--
Emil


" wrote:

hi Emil,
that depends on how the sheets are hidden (hidden or veryhidden).
if only hidden, try Format/Sheet/Unhide
if veryhidden, you can open the VBA editor and change the visible-
option of a sheet from veryhidden to visible.

bye
stefan

On 20 Mai, 08:08, emilh wrote:
Hi.

I have received an excel file with vba and it has the code which prevents
the file to display most sheets. Is there any way (user level) other than
deleting or commenting that section of code to display the sheets?

Thank you.
--
Emil

Invisible sheets
 

Hi Emil,

Try pating the following code into a
standard module:

'==========
Public Sub Tester()
Dim WB As Workbook
Dim SH As Worksheet

Set WB = ActiveWorkbook
For Each SH In WB.Worksheets
SH.Visible = xlSheetVisible
Next SH
End Sub
'<<==========

Assign a shortcut key to the macro and
use the key combination to display all
sheets at any point



---
Regards.
Norman
"emilh" wrote in message
...
Thanks stefan.

it's 'xlSheetVeryHidden'

it seems that the only way is change the code each time i want to access
the
data in those sheets?

--
Emil


" wrote:

hi Emil,
that depends on how the sheets are hidden (hidden or veryhidden).
if only hidden, try Format/Sheet/Unhide
if veryhidden, you can open the VBA editor and change the visible-
option of a sheet from veryhidden to visible.

bye
stefan

On 20 Mai, 08:08, emilh wrote:
Hi.

I have received an excel file with vba and it has the code which
prevents
the file to display most sheets. Is there any way (user level) other
than
deleting or commenting that section of code to display the sheets?

Thank you.
--
Emil

Invisible sheets
 

Hi Emilh,

If , however, the workbook might contain
non-worksheet sheets (a chart, for example),
try the following version:

'==========
Public Sub Tester()
Dim WB As Workbook
Dim SH As Object

Set WB = ActiveWorkbook
For Each SH In WB.Sheets
SH.Visible = xlSheetVisible
Next SH
End Sub
'<<==========


---
Regards.
Norman

Invisible sheets
 

hi Emil,
you can use code like Norman posted it.
if the sheets are hidden on opening the workbook (Workbook_Open
event), you can press the SHIFT key while opening (via file/open in
Excel).
Excel doesn´t start code in Workbook_Open then.

bye
stefan

On 20 Mai, 09:36, emilh wrote:
Thanks stefan.

it's 'xlSheetVeryHidden'

it seems that the only way is change the code each time i want to access the
data in those sheets?

--
Emil

Invisible sheets
 

Thank you very much guys. Shift didn't work. I'll try Norman's code
--
Emil


" wrote:

hi Emil,
you can use code like Norman posted it.
if the sheets are hidden on opening the workbook (Workbook_Open
event), you can press the SHIFT key while opening (via file/open in
Excel).
Excel doesn´t start code in Workbook_Open then.

bye
stefan

On 20 Mai, 09:36, emilh wrote:
Thanks stefan.

it's 'xlSheetVeryHidden'

it seems that the only way is change the code each time i want to access the
data in those sheets?

--
Emil