Excel workbook automaticly goes to certain sheet

[Hidden999]

Quick question. When I open my shared workbook on work it automaticly goes to a certain sheet even when I saved it on another sheet. How is this possible?

Thanks in advanced!

 

[WaterGypsy]

Look at the On Open (?) code

 

[Hidden999]

Where to find this code?

 

[WaterGypsy]

ALT-F11 to open the code box, then right click on ThisWorkbook and select ViewCode

 

[jmacleary]

WaterGypsy as its a shared workbook the OP won't be able to view the code.

Hidden999 I suggect you do a save as to a temporary filename, then unshare the workbook, then you can look at the code. If there is code there, I guess you need to consult with other sharers if you are thinking of changing it.

 

[jmacleary]

Hidden999 - also, as its a shared workbook, maybe someone else who shares it has saved it after you and they were on the sheet that opens.