Excel VBA: Jump to hidden worksheets?

DesbaByDesba

Hello Community,

I have a small VBA problem in Excel.

The situation: I have a workbook with several worksheets. These sheets are displayed in a dropdown menu. Using a command button, I then jump to the worksheet previously selected in the dropdown menu:

Here is the code of the command button:

 Private Sub CommandButton1_Click()    ThisWorkbook.Sheets(Range("D7").Value).Select End Sub

However, this code only works as long as I also display the sheets at the bottom of the folder.

Now to my question: What should the code look like if I hide the worksheets?

(1 votes)
Loading...

Similar Posts

Suddenly can't upload anything via Frontpage anymore.?

Bychasperli1965

My provider simply says it only works with FileZilla. You changed your connection details about a year ago, and it worked until yesterday, and then suddenly it stopped working? So what's the problem? You're just uploading data. I know that FP is old, there's no need to discuss that at the moment.

To the script experts: how to speed up javascript games?

Byanonym200886

I copied a ping-pong game from kostenlose javascripts.de for my website. It's meant to be a casual game, but still fun. But it's so slow that it's no challenge to catch the ball before it goes out of bounds. So, how can I speed up the game? https://www.kostenlose-javascripts.de/javascripts/spiele/pong/

Subscribe
Notify of
1 Answer
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Desba
Author
Desba
1 year ago

Problem is solved!

If someone has the same problem and stumbles on this question, here is the working code:

Private Sub CommandButton1_Click()
  
    Sheets(Range("D7").Value).Visible = True 
    ThisWorkbook.Sheets(Range("D7").Value).Select
          
End Sub

The selected table is thus visible. In the second step, it is navigated directly there.

On the respective table there is a button to get back to the dashboard. So that the table is also hidden again, simply enter the following at the end of the code for the respective button:

Sheets("TABELLENNAME").Visible = False

In TABELLENNAME, of course, take the name of the table to be hidden.

Maybe it’ll help someone sometime.

1