Mark_J Wrote:
In Microsoft Excel how do you open a workbook to ensure it only opens
one a
specified worksheet, no matter what spreadsheet you last saved the
workbook
in.
It is VARY do able. In
VB go to your project and click the
ThisWorkbook
Paste the following-----
Option Explicit
Private Sub Workbook_Open()
Sheets("ENTER YOUR WORKSHEET NAME HERE").Select
End Sub
Your workbook will open at the sheet you enetered evry time regardless
when it was saved on.
Good Luck
Pat
--
jenkinspat