Maintain focus on one worksheet while collecting data in others
 

I have a spreadsheet whose first worksheet has calculations.

The back pages of the spreadsheet gather real time data every minute.

I would like to be able to keep the focus on the calculation sheet; make it
so the data gathering pages keep gathering without the focus of the program
going to them while they do it.

Is there a way to do this?

Thanks!

Maintain focus on one worksheet while collecting data in others
 

Have you got Application.ScreenUpdating = False anywhere in your code?

"evilpixie" wrote:

I have a spreadsheet whose first worksheet has calculations.

The back pages of the spreadsheet gather real time data every minute.

I would like to be able to keep the focus on the calculation sheet; make it
so the data gathering pages keep gathering without the focus of the program
going to them while they do it.

Is there a way to do this?

Thanks!

Maintain focus on one worksheet while collecting data in other
 

No... Would that stop it from cycling around the data pages?

"bigwheel" wrote:

Have you got Application.ScreenUpdating = False anywhere in your code?

"evilpixie" wrote:

I have a spreadsheet whose first worksheet has calculations.

The back pages of the spreadsheet gather real time data every minute.

I would like to be able to keep the focus on the calculation sheet; make it
so the data gathering pages keep gathering without the focus of the program
going to them while they do it.

Is there a way to do this?

Thanks!

Maintain focus on one worksheet while collecting data in other
 

Not sure, but worth a try I would think

"evilpixie" wrote:

No... Would that stop it from cycling around the data pages?

"bigwheel" wrote:

Have you got Application.ScreenUpdating = False anywhere in your code?

"evilpixie" wrote:

I have a spreadsheet whose first worksheet has calculations.

The back pages of the spreadsheet gather real time data every minute.

I would like to be able to keep the focus on the calculation sheet; make it
so the data gathering pages keep gathering without the focus of the program
going to them while they do it.

Is there a way to do this?

Thanks!