Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On opening a worksheet move focus to a cell based on date | Excel Worksheet Functions | |||
Hyperlinks opening wrong application | Excel Discussion (Misc queries) | |||
HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
Code Repeats Itself And Goes To Wrong Focus | Excel Programming | |||
Wrong Macro opening | Excel Programming |