VBA - Remain on 'Active Page'

[Peter Muller]

Good afternoon,

I have a macro that does multiple tasks on different sheets in my workbook.

I have the same macro button on each sheet. When I run the macro, it does what I want it to, but my cursor does not remain on the active sheet, but jumps to a different sheet.


I am looking for code to keep the cursor on the active sheet and not jump to another.

I tried various options, but none works, e.g.,

With ActiveSheet

Range("A1").Select

End With


Please help

 

[Peter Muller]

Try stepping through the code line by line using F8 to see where it changes sheets.

Now I am really baffled. When I step through the code, even a few times, the sheet does not change. When I run the code from the button, it does not change the first time, but when I run it a second time from the button without first running the unprotect macro, it jumps to "Report"

 

[Fluff]

Are you talking about the code in post#7?

 

[Peter Muller]

Are you talking about the code in post#7?

Yes, and double checked to ensure that i am not missing something

 

[Fluff]

Do you have any event code in the Reports sheet?

 

[Peter Muller]

No event code

Do you have any event code in the Reports sheet?

 

[Fluff]

In that case I have no idea, as there is nothing in the code you posted that would cause the active sheet to change.

 

[Peter Muller]

In that case I have no idea, as there is nothing in the code you posted that would cause the active sheet to change.

Okay, thank you for trying. Will just have to select the page manually.

 

[Fluff]

You can always use the approach suggested by richh

 

[Peter Muller]

You can always use the approach suggested by richh

Okay, thanks, will have a look at that