Calling all VBA Genius's
I have an excel 2007 workbook containing a load of 'veryhidden' worksheets
I usually unhide with the following script but today its not happening!
Any ideas?
Sub UnhideAll()
Dim WS As Worksheet
For Each WS In Worksheets
WS.Visible = xlSheetVisible
Next
End Sub