Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Start sheet in a workbook
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Start sheet in a workbook
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. try it with Workbook_Open-Event (suit to modify): Private Sub Workbook_Open() Application.Goto Sheets("Tabelle1").Range("A1") End Sub Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Start sheet in a workbook
Am Donnerstag, 14. Februar 2013 11:21:34 UTC+1 schrieb 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. try it with Workbook_Open-Event (suit to modify): Private Sub Workbook_Open() Application.Goto Sheets("Tabelle1").Range("A1") End Sub Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save each sheet of multi-sheet workbook as a single-sheet workbook | Excel Programming | |||
Copy rows onto existing sheet / start a new sheet if full | Excel Programming | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
Start a sheet event when i leave a sheet | Excel Programming |