how do I view an "xlsheethidden" sheet

  • Thread starter Thread starter fghjkl
  • Start date Start date
F

fghjkl

Hi
I have been given a workbook with a few sheets in it. I need to be able
to view the sheets but the book is in a macro and the sheet are
xlsheethidden according to VB.
Any ideas.
Thanks
F
 
Hi F

If it's a workbook then run this:

Sub ShowEm()
Dim L As Long
For L = 1 To Sheets.Count
Sheets(L).Visible = True
Next
End Sub

But if you by "in a macro" means that it's an add-in file, open the ThisWorkbook module
and set the IsAddin property to false. And maybe you'll have to run my macro after that.
 
Back
Top