View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
bony_tony bony_tony is offline
external usenet poster
 
Posts: 76
Default How to I make sure that my workbook always opens with a desired sh

Use this macro code to select the desired sheet when opening

Private Sub Auto_Open()
Sheets("The sheet name").Select
End Sub

Tony

On Dec 20, 8:59 pm, Shariq wrote:
Hi!
I've got a problem. I want to make sure that everytime I open a workbook, to
make it open always with the same page/sheet I want, because normally it will
open the sheet you were working on last.(before you closed it).
so please if someone can help me.