View Single Post
  #4   Report Post  
jenkinspat
 
Posts: n/a
Default


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