How to I make sure that my workbook always opens with a desire
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.
|