I've developed an app for our call center managers to use for evaluating and scoring employee calls from customers. It has several worksheets in the background, and the main form (worksheet) used for scoring the calls. The other sheets aren't hidden, but I have the tabs not visible, so they are effectively inaccessible to the users. I've added a button to the form for them to produce a list of all scores for all employees. I'm creating the list on a "ScoreList" sheet, with a "Back" button to get back to the main form.

It works fine when I have tabs visible, but when not, the line, Sheets("ScoreList").Select gets "Select method of worksheet class failed". If I change it to Sheets("ScoreList").Activate, the code apparently runs and builds the list, but it doesn't activate the sheet, so it looks like nothing happens.

If I put in a debug stop, it tells me that the active sheet is ScoreList, but the display is blank, and when I let the code finish, it goes back to the form.

How do I show another sheet when tabs aren't visible?