Hello Marieme,
According to your sample Workbook your Code should actually read:
Otherwise you could refer to the Actual Sheet as follow;
Private Sub CommandButton1_Click() ThisWorkbook.Sheets("Sheet4").Select End Sub
Hope that helps.Private Sub CommandButton1_Click() ThisWorkbook.Sheet1.Select ' which is named Sheet4 End Sub
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi Winon,
Thank you for your suggestion. Tried that but it's not opening the sheet I am interested in which is the one that have the data.
It's finally sorted!!! I retried the 2nd option Winon suggested and somehow it worked (must've made a mistake in the command the first time).
Thank you very much you all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks