Select a sheet when tabs not visible

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?

That gets "Select method of range class failed".

Must be something to do with the interaction with the form. There's no reason why you can't select a sheet just because the tab isn't visible.

This example is in the Immediate Window:

Please Login or Register  to view this content.

All that said, you don't need to select anything in order to manipulate it.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Well ... it turns out I lied. The sheets are hidden after all, so that explains it. Sorry for the confusion, and thanks for the replies.

You're welcome.


Well, you still don't need to select anything in order to manipulate it.

And it would be more efficient if you didn't. But, your choice.





If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

No, but you do need to select it to show them the report

Fair enough, if that's what you're doing.