I read that post wrong. Disregard my previous suggestion.


"JLGWhiz" wrote in message
...
You can run this macro.


Sub due()
For i = 2 To ThisWorkbook.Sheets.Count
If Sheets(i).Visible = False Then
Sheets(i).Visible = True
Next
End Sub


"Saucer Man" wrote:

I have a macro that creates many temporary sheets and then deletes them.
It
creates so many that my original sheets get hidden on the left of excel.
After the deletes, it doesn't move the sheets that are hidden on the left
back into view. Is there a VBA statement that will accomplish this?

--
Thanks!