IF Statement to not follow a procedure of sheet is Hidden

[sherylt13]

Hello, am trying to finalize a macro that will include ability to re-run, however after the first time the macro is run, it hides and protects a sheet that no longer needs action. When running a second time, the code looks for that sheet (so obviously errors out there) to perform an action already completed.

With that, am looking for assistance with code to say, something like, if sheet.abc is hidden, do not Call Macro123, else Call Macro123. This could help for running both the first and then subsequent runs.

Hope that makes sense. Thanks in advance for any assistance.
Sheryl

[jeffreybrown]

Hi Sheryl,

To check whether the sheet is visible...

If Sheet2.Visible = xlSheetHidden Then

'Do Nothing

Else

Call Macro

End If

[sherylt13]

Thanks for the quick response.

Sheryl