Changing the focus in an inactive sheet.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AVR - 31 Jan 2007 19:39 GMT

I am working in a workbook with multiple sheets. A change event in sheet A
triggers some manipulations of data and ranges in sheet B. It also changes
the cell selection the next time sheet B is activated. Is there a way to set
the selected cell for the next opening of sheet B, without having it reset
every time sheet B is activated. Ideally, I would like to do it without
sheet B having to "flash" open to the user.

Reply to this Message

Tom Ogilvy - 31 Jan 2007 19:46 GMT

Sub SetActiveCell()
application.ScreenUpdating = False
set sh = Activesheet
With Worksheets("Sheet B")
.Select
.Range("F9").Select
End with
sh.Activate
Application.ScreenUpdating = True
End sub

Signature

Regards,
Tom Ogilvy

> I am working in a workbook with multiple sheets. A change event in sheet A
> triggers some manipulations of data and ranges in sheet B. It also changes
> the cell selection the next time sheet B is activated. Is there a way to set
> the selected cell for the next opening of sheet B, without having it reset
> every time sheet B is activated. Ideally, I would like to do it without
> sheet B having to "flash" open to the user.

Reply to this Message

merjet - 31 Jan 2007 22:24 GMT

Is the change event of Sheet A due to VBA code? If yes, modify the
code to capture Sheet B's ActiveCell address at the start and reselect
said ActiveCell at the end.

Hth,
Merjet

Reply to this Message

merjet - 31 Jan 2007 22:28 GMT

Is the change event of Sheet A due to VBA code? If yes, modify the
code to capture Sheet B's ActiveCell address at the start and reselect
said ActiveCell at the end.

Hth,
Merjet

Reply to this Message