Prev: Help to resove this problem.
Next: Excel is reading formula as a value
From: Mr E on 9 Apr 2010 10:51
I am trying to force excel to open to the same workesheet each time the work
book is opened. regardless of where it was last saved. Is this possible? If
so, how would you accomplish this.
From: Gary Brown on 9 Apr 2010 13:53
In the 'ThisWorkbook' module, put the following code (adapted to the
worksheet you want)...

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Mr E" wrote:

> I am trying to force excel to open to the same workesheet each time the work
> book is opened. regardless of where it was last saved. Is this possible? If
> so, how would you accomplish this.
 | 
Pages: 1
Prev: Help to resove this problem.
Next: Excel is reading formula as a value