Hello, I created code for when an Open event occurs, but can't control what is selected at that time. I'm getting errors. I have this:
Private Sub Workbook_Open()
If Application.CommandBars("Ribbon").Controls(1).Height > 100 Then
Application.CommandBars.ExecuteMso "MinimizeRibbon"
End If
Application.DisplayFormulaBar = False
Sheets("Scenarios").Range("B2:V2").Select
ActiveWindow.Zoom = True
Sheets("Scenarios").Shapes("Group 25").Visible = False
Sheets("Scenarios").Shapes("Chevron 6").Visible = True
Sheets("Scenarios").Range("I4").Select
Application.Goto Reference:=Worksheets("Guide")
End Sub
This is an .xltm template file. If I save the template beforehand while on the "Scenarios" sheet, it will have a problem activating the last jump to the "Guide" sheet when I open it again. But, if I save previously while on the "Guide" sheet, it will have a problem right away with just selecting for the zoom in "Scenarios". It all depends on how I save the template beforehand.
What I really want the workbook to do is open to "Guide" (with no visible cell highlighted), but when the user goes to the the "Scenarios" sheet, Range I4 is selected so that can be the first thing she has to change.
Any suggestions? Did that make sense? I feel like .Select would just go wherever I want, but in reality may need an .Activate to get it there properly. Where am I wrong? Thank you.
Bookmarks