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