Hi Shariq

you could put following code in the ThisWorkbook part:

Private Sub Workbook_Open()
ActiveWorkbook.Sheets("xxxxx").Activate
End Sub

where "xxxxx" is the name of the sheet you want to open.

hth Carlo

"Shariq" wrote:

Hi!
I've got a problem. I want to make sure that everytime I open a workbook, to
make it open always with the same page/sheet I want, because normally it will
open the sheet you were working on last.(before you closed it).
so please if someone can help me.