Sheets.Add but stay in the old sheet?

[HerryMarkowitz]

Greetings,
Following code adds a new sheet.
Then new sheets be ActiveSheet. (I dont want this)

Please Login or Register  to view this content.

So, how to add new sheet but stay in the old sheet?
Regards...

[Norie]

As far as I know that isn't possible, if you add a new sheet it becomes the active sheet.

Is there a reason you don't want that to happen?

[DBY]

Hello
Try:

Please Login or Register  to view this content.

Seems to work for me.

DBY

[HerryMarkowitz]

Thanks a lot...
But I am looking for a code which adds a new sheet by staying in the old sheet...
Any idea?

[DBY]

That is what the code does when I run it. If you run this from say sheet 1 it adds a new sheet and stays on sheet 1.

[HerryMarkowitz]

That is what the code does when I run it. If you run this from say sheet 1 it adds a new sheet and stays on sheet 1.

Hi DBY,
I understand that.
Your code works.
But I dont want any movement...

[HerryMarkowitz]

Solved.

Please Login or Register  to view this content.

[DBY]

I see. It was the screen flicker you wanted removed. Yes, ScreenUpdating will clear that. Glad it's solved.