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
|