I know this may be a crazy question but....

I have code where i have to activate the sheet in order for the code
correctly. Now, I dont want that sheet to be displayed because it slows down
the macro. Is there a way to either Activate the sheet and not have it
displayed or another way to disable screen updating besides
Application.ScreenUpdating = False cause that doesnt work

thanks

There are very few things that depend on the activesheet.

I think I'd try to rewrite the code that depends on the activesheet.

And I've never seen .screenupdating fail. I have seen it turn on when I used
something out of the Analysis toolpak (IIRC). But since I can't control that,
I'll just add another .screenupdating = false to freeze it when the ATP call
finishes.



CLamar wrote:
>
> I have code where i have to activate the sheet in order for the code
> correctly. Now, I dont want that sheet to be displayed because it slows down
> the macro. Is there a way to either Activate the sheet and not have it
> displayed or another way to disable screen updating besides
> Application.ScreenUpdating = False cause that doesnt work
>
> thanks

--

Dave Peterson

Do you have any suggestions for not having the sheet active in order to
proceed with the code. When I dont make the sheet active it gives me the
error "Method 'Range' of object Global failed". Here is an example of the
code:
The error occurs at the line beginning with newfbr when i comment out the
Sheets("Plotdata").Activate line

Do Until oldfbr > LastCellVRH1x
Sheets("AreaSolver").Range(PS.Cells(8, 1), PS.Cells(36, 6)).Clear
'Sheets("PlotData").Activate
With Sheets("PlotData")
top = oldfbr
newfbr = Range("F" & oldfbr & "").End(xlDown).Row
bottom = newfbr
oldfbr = newfbr + 3
SerialName = Sheets("Sheet4").Range("E" & i & "").Value
ChartTitle = Sheets("Sheet4").Range("C" & i & "").Value
TestMethod = Sheets("TestTable").Range("I" & i + 1 & "").Value
AreaLabel = Sheets("Sheet4").Range("E" & i & "").Value & " / " & _
Sheets("Sheet4").Range("D" & i & "").Value

"Dave Peterson" wrote:

> There are very few things that depend on the activesheet.
>
> I think I'd try to rewrite the code that depends on the activesheet.
>
> And I've never seen .screenupdating fail. I have seen it turn on when I used
> something out of the Analysis toolpak (IIRC). But since I can't control that,
> I'll just add another .screenupdating = false to freeze it when the ATP call
> finishes.
>
>
>
> CLamar wrote:
> >
> > I have code where i have to activate the sheet in order for the code
> > correctly. Now, I dont want that sheet to be displayed because it slows down
> > the macro. Is there a way to either Activate the sheet and not have it
> > displayed or another way to disable screen updating besides
> > Application.ScreenUpdating = False cause that doesnt work
> >
> > thanks
>
> --
>
> Dave Peterson
>