I have a workbook that will always contain at least one visible worksheet.
The number of visible worksheets may vary, but the workbook will always
contain at least one visible and one hidden worksheet.

I would like to add the following logic to run with an on open workbook
event but am having a hard time piecing together the proper VB code.

On Workbook Open,
For each visible worksheet within the workbook,
IF cell A1="Input",
THEN run formatting macro,
ELSE do nothing.

Any help is much appreciated.