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.

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.

Hi Carlo!
First of all thanx for your reply, I've done what you said, perhaps
something missing yet or I'm doing something wrong, but the problem still
persist, it still goes to the sheet, I was working last, can you maybe give
me some more tips.
Shariq,


"Carlo" wrote:

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.

Hi Shariq

tell me what you did exactly, so that i can follow your steps.
- Where did you put the code
- What name did you enter
and so on.

Carlo

"Shariq" wrote:

Hi Carlo!
First of all thanx for your reply, I've done what you said, perhaps
something missing yet or I'm doing something wrong, but the problem still
persist, it still goes to the sheet, I was working last, can you maybe give
me some more tips.
Shariq,


"Carlo" wrote:

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.

After opening the workbook, I clicked on the bottom, clicked on view code and
followed the rest in fact I copied and paste that what you had sent me, only
the sheet name I had changedin (brakets), then closed the workbook, reopened
it but it still didn't work.
So tell me if I've done something wrong, or I have to do some more in
addition to that.
thanx again,
Shariq

"Carlo" wrote:

Hi Shariq

tell me what you did exactly, so that i can follow your steps.
- Where did you put the code
- What name did you enter
and so on.

Carlo

"Shariq" wrote:

Hi Carlo!
First of all thanx for your reply, I've done what you said, perhaps
something missing yet or I'm doing something wrong, but the problem still
persist, it still goes to the sheet, I was working last, can you maybe give
me some more tips.
Shariq,


"Carlo" wrote:

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.

Hi Shariq

after you click "view code" Excel shows you the VBA-editor. But there you are
changeing the Code of the Sheet and not the one of the Book. So, in the
Project-
Explorer (Ctrl + R) you can go to the "thisWorkbook" and paste the code in
there.
You have to be careful, that you enter the name with "".

hope it works now

Cheers
Carlo

"Shariq" wrote:

After opening the workbook, I clicked on the bottom, clicked on view code and
followed the rest in fact I copied and paste that what you had sent me, only
the sheet name I had changedin (brakets), then closed the workbook, reopened
it but it still didn't work.
So tell me if I've done something wrong, or I have to do some more in
addition to that.
thanx again,
Shariq

"Carlo" wrote:

Hi Shariq

tell me what you did exactly, so that i can follow your steps.
- Where did you put the code
- What name did you enter
and so on.

Carlo

"Shariq" wrote:

Hi Carlo!
First of all thanx for your reply, I've done what you said, perhaps
something missing yet or I'm doing something wrong, but the problem still
persist, it still goes to the sheet, I was working last, can you maybe give
me some more tips.
Shariq,


"Carlo" wrote:

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.