how do i jump to certain part of a document as soon as it is ope

[Excel]

how do i go straight to a certain area of text within a document without
using goto?
I want the document to open at a specific part of the doc not at the start
of the doc

 

[Suzanne S. Barnhill]

Go To is the only way to go to a specific part of the document (bookmark).
You can automate this with an AutoOpen macro, but in most cases this will
require you to reply to a dialog before the macro will be enabled, which is
usually more trouble than it's worth. If the place you want to go to is the
last edit, use Shift+F5.

 

[Greg]

You can get around the macro security warning that Suzanne mentions by
putting the macro in your document template. Bookmark the spot in any
document you want to use this feature with as "OpenHere".

Put this code in an AutoOpen macro:

On Error GoTo Ignore
If ActiveDocument.Bookmarks("OpenHere") > "" Then
Selection.GoTo What:=wdGoToBookmark, Name:="OpenHere"
End If
Ignore: Err.Clear