Maybe this:
Private Sub Workbook_Open()
Sheets("Sheet1").Activate
End Sub
It needs to go in 'ThisWorkbook', object.
Also, take a look at this:
http://exceltip.com/st/Cell_Function..._Path/180.html
Remember, you have to save your WB before the change becomes effective.
Regards,
Ryan---
--
RyGuy
"John" wrote:
In a workbook I want to find the workssheet that has a a particular name
in cell C1, make it the active sheet and get the name(tab) of the sheet
into a variable.
Help
JOhn