I need help to create a macro that would move me back to an existing Excel worksheet. I've created a program that plays an MP3 song on windows media player and the user must click on one of four macro buttons to name the song. The problem is that the player must first click anywhere on the Excel worksheet before being able to click on the button to name the song. I have used "'ActiveWorkbook.Worksheets("Sheet1").Select", "Sheets("Sheet1").Select" and "Sheets("Sheet1").Activate" and none of those lines gets me back to the worksheet. I would like to eliminate the current need to essentially double click to run the macro button.
Any assistance is greatly appreciated. Thank you.