Been struggling for a while with this one.
ActiveWindow.SelectedSheets.Visible = False
The above Vba works just fine to close the worksheet that I am in from a command button, but what I need is from a particular worksheet, lets call it 'WINE', is to close and return to one of two worksheets that may be open, "DASBOARD" or "VINO"
Any ideas as I am completely stumped on this.
Just an extra, either one or the other will be open, but neither at the same time