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

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

software

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