Hi,
I would like to create a command button that shows the next active sheet.
normally I use codes ActiveSheet.Next.Select and ActiveSheet.Previous.Select for showing next and previous sheet.
Let's say that out of sheets 2, 3, 4, and 5, only one is visible depending on the variable of the same name as the next visible sheet shown in a cell of the sheet 1.
What code can I use to move to that next visible sheet?
Thanks
Bookmarks