I have a workbook with several worksheets. I hide some worksheets for
various reasons. I have navigation buttons on each worksheet that are
support to go to the previous or the next worksheet. The macro code I'm
using is:

Prev: ActiveSheet.Previous.Next

Next: ActiveSheet.Next.Select

If the next sheet has been hidden, I get a run-time error '1004'. How
can I move to the next visible worksheet ?