close

XP Profesional
How do I ensure that a workbook opens on the same worksheet every time

Pieter, one way if macros are enabled, put in this workbook code,

Private Sub Workbook_Open()
Sheets(quot;Sheet2quot;).Select
Range(quot;A1quot;).Select
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Pieterquot; gt; wrote in message
...
gt; XP Profesional
gt; How do I ensure that a workbook opens on the same worksheet every time

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()