Start sheet in a workbook

S

Stuart

I use Excel 2010.
In one workbook, which I use frequently, I always want to open at the same sheet.
I found a setting in Options once and it worked fine but now I cannot find this setting, in order to change it to another sheet.
Can anyone help ?

Stuart in Zurich
 
C

Claus Busch

Hi Stuart,

Am Thu, 14 Feb 2013 01:34:04 -0800 (PST) schrieb Stuart:
I use Excel 2010.
In one workbook, which I use frequently, I always want to open at the same sheet.
I found a setting in Options once and it worked fine but now I cannot find this setting, in order to change it to another sheet.
Click to expand...

try it with Workbook_Open-Event (suit to modify):

Private Sub Workbook_Open()
Application.Goto Sheets("Tabelle1").Range("A1")
End Sub


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Excel Macro to un-mute Audio/speakers. 15
Connecting a master sheet to other sheets within the same workbook 3
Move/Copy sheet to another workbook error 2
Using a Windows Shortcut to Open to Specific Sheet in Workbook 4
Excel, assign cells in multiple worksheets from one sheet 1
Open a excel workbook always on the same sheet 1
change links to a different source in the same workbook 2

Top