Focus is on wrong sheet after opening.
 

On Fri, 23 Mar 2007 22:38:55 -0000, "Roger Govier"
wrote:

Hi

You could prevent the flicker with
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Sheets("the sheet to view on opening here").select
Application.ScreenUpdating = True
end sub

Thanks. Will give that a try tomorrow. :oD

--
Regards

Roger Govier


"StargateFanFromWork" wrote in message
...
"Anthony" wrote in message
...
Hi,
I am no expert on VB code, but have you tried adding

Private Sub Workbook_Open()
Sheets("the sheet to view on opening here").select
end sub

to the ThisWorkbook part of the VB editor?
just a thought!

Hallelujah! Thanks goodness. That works. It flickers to the back
sheet but then scoots back to the first and you can hardly see it;
just a flicker. But it gets the job done. I've never seen this
behaviour before. But no matter. The user opens up the doct and it
comes up with floating commandbar, too. Everything seems a-okay.
This is great. Thanks much. :oD

"StargateFanFromWork" wrote:

I've never had this happen before. When I open up a workbook, it
doesn't
open up to the first sheet. It starts that way but then flips to
the last
one. It doesn't matter if the doct. was saved while on the first
sheet, it
always reverts to the last one next time it's opened.

The other two sheets besides the main one are just information
sheets that
the user will rarely need but must be there. Is there any way to
have the
main sheet be the one that is seen after opening?

Some specs: this is an Excel doct. saved in a DOCSopen environment,
which
shouldn't be an issue at all, but thought I'd mention it. XL2K on a
recent
upgrade to WinXP from Win2K.

Thanks. :oD