Use the Workbook.Open event in the Object Module ThisWorkbook

Private Sub Workbook_Open()
Sheets("MyWorksheetName").Activate
End Sub


"Don J" wrote in message
:

I always want Excel to start on a specific Worksheet whenever I open a
particular Workbook. How can I do that?

Don J

-----------------------------------------------------

I don't know how to do this. What is the 'Workbook.Open' event? Also where
is the 'Object Module', and what is 'ThisWorkbook'?

Don J

------------------------------------------------------------------------------
"JMay" wrote in message
...
Use the Workbook.Open event in the Object Module ThisWorkbook

Private Sub Workbook_Open()
Sheets("MyWorksheetName").Activate
End Sub


"Don J" wrote in message
:

I always want Excel to start on a specific Worksheet whenever I open a
particular Workbook. How can I do that?

Don J

-----------------------------------------------------

Don

With your workbook open, right-click on the Excel logo left of "File" if your
window is maximized or on the title bar Excel logo if not maximized.

Select "View Code" and Thisworkbook module will open.

Paste JMay's code into that module............make sure to substitute your real
worksheet name instead of "MyWorksheetName". The double quotes must be used.

Close that window. Save your workbook and close it.

Each time you open it, it will open to the worksheet you have named no matter
where you were when you last saved/closed.


Gord Dibben MS Excel MVP

On Tue, 20 Feb 2007 20:47:15 -0500, "Don J" wrote:

I don't know how to do this. What is the 'Workbook.Open' event? Also where
is the 'Object Module', and what is 'ThisWorkbook'?

Don J

------------------------------------------------------------------------------
"JMay" wrote in message
...
Use the Workbook.Open event in the Object Module ThisWorkbook

Private Sub Workbook_Open()
Sheets("MyWorksheetName").Activate
End Sub


"Don J" wrote in message
:

I always want Excel to start on a specific Worksheet whenever I open a
particular Workbook. How can I do that?

Don J

-----------------------------------------------------

When I load the Workbook I get a "Microsoft Excel" error that says:

"Macros are disabled because the security level is set to high and a
digitally signed Trusted Certificate is not attached to the macros. To run
the macros, change the security level to a lower setting (not recommended),
or request the macros be signed by the author using a certificate issued by
a Certificate Authority."

Sounds like setting the security level lower would be the easiest thing to
do. How do I do it?

Don J

------------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Don

With your workbook open, right-click on the Excel logo left of "File" if
your
window is maximized or on the title bar Excel logo if not maximized.

Select "View Code" and Thisworkbook module will open.

Paste JMay's code into that module............make sure to substitute your
real
worksheet name instead of "MyWorksheetName". The double quotes must be
used.

Close that window. Save your workbook and close it.

Each time you open it, it will open to the worksheet you have named no
matter
where you were when you last saved/closed.


Gord Dibben MS Excel MVP

On Tue, 20 Feb 2007 20:47:15 -0500, "Don J" wrote:

I don't know how to do this. What is the 'Workbook.Open' event? Also
where
is the 'Object Module', and what is 'ThisWorkbook'?

Don J

------------------------------------------------------------------------------
"JMay" wrote in message
...
Use the Workbook.Open event in the Object Module ThisWorkbook

Private Sub Workbook_Open()
Sheets("MyWorksheetName").Activate
End Sub


"Don J" wrote in message
:

I always want Excel to start on a specific Worksheet whenever I open a
particular Workbook. How can I do that?

Don J

-----------------------------------------------------

Tools|Macro|Security|Security level tab

Change to Medium (to be prompted each time you open a workbook with macros)
change to low (to avoid the prompt, MS recommends against this)

And then close your workbook and reopen it.

Don J wrote:

When I load the Workbook I get a "Microsoft Excel" error that says:

"Macros are disabled because the security level is set to high and a
digitally signed Trusted Certificate is not attached to the macros. To run
the macros, change the security level to a lower setting (not recommended),
or request the macros be signed by the author using a certificate issued by
a Certificate Authority."

Sounds like setting the security level lower would be the easiest thing to
do. How do I do it?

Don J

------------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Don

With your workbook open, right-click on the Excel logo left of "File" if
your
window is maximized or on the title bar Excel logo if not maximized.

Select "View Code" and Thisworkbook module will open.

Paste JMay's code into that module............make sure to substitute your
real
worksheet name instead of "MyWorksheetName". The double quotes must be
used.

Close that window. Save your workbook and close it.

Each time you open it, it will open to the worksheet you have named no
matter
where you were when you last saved/closed.


Gord Dibben MS Excel MVP

On Tue, 20 Feb 2007 20:47:15 -0500, "Don J" wrote:

I don't know how to do this. What is the 'Workbook.Open' event? Also
where
is the 'Object Module', and what is 'ThisWorkbook'?

Don J

------------------------------------------------------------------------------
"JMay" wrote in message
...
Use the Workbook.Open event in the Object Module ThisWorkbook

Private Sub Workbook_Open()
Sheets("MyWorksheetName").Activate
End Sub


"Don J" wrote in message
:

I always want Excel to start on a specific Worksheet whenever I open a
particular Workbook. How can I do that?

Don J

-----------------------------------------------------




--

Dave Peterson

Thank you "J May", "Gord Dibben" and "Dave Peterson". You have all
contributed to my being able to successfully open a Workbook to a specific
Worksheet. Thank you again!

Don J

--------------------------------------------------------------------------------



"Dave Peterson" wrote in message
...
Tools|Macro|Security|Security level tab

Change to Medium (to be prompted each time you open a workbook with
macros)
change to low (to avoid the prompt, MS recommends against this)

And then close your workbook and reopen it.

Don J wrote:

When I load the Workbook I get a "Microsoft Excel" error that says:

"Macros are disabled because the security level is set to high and a
digitally signed Trusted Certificate is not attached to the macros. To
run
the macros, change the security level to a lower setting (not
recommended),
or request the macros be signed by the author using a certificate issued
by
a Certificate Authority."

Sounds like setting the security level lower would be the easiest thing
to
do. How do I do it?

Don J

------------------------------------------------------------------------------

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Don

With your workbook open, right-click on the Excel logo left of "File"
if
your
window is maximized or on the title bar Excel logo if not maximized.

Select "View Code" and Thisworkbook module will open.

Paste JMay's code into that module............make sure to substitute
your
real
worksheet name instead of "MyWorksheetName". The double quotes must be
used.

Close that window. Save your workbook and close it.

Each time you open it, it will open to the worksheet you have named no
matter
where you were when you last saved/closed.


Gord Dibben MS Excel MVP

On Tue, 20 Feb 2007 20:47:15 -0500, "Don J"
wrote:

I don't know how to do this. What is the 'Workbook.Open' event? Also
where
is the 'Object Module', and what is 'ThisWorkbook'?

Don J

------------------------------------------------------------------------------
"JMay" wrote in message
...
Use the Workbook.Open event in the Object Module ThisWorkbook

Private Sub Workbook_Open()
Sheets("MyWorksheetName").Activate
End Sub


"Don J" wrote in message
:

I always want Excel to start on a specific Worksheet whenever I open
a
particular Workbook. How can I do that?

Don J

-----------------------------------------------------




--

Dave Peterson