View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Norman Jones
 
Posts: n/a
Default Opening a tab automatically in a file

Hi Jay,

Try:

'=============
Private Sub Workbook_Open()
Me.Sheets("Menu").Select
End Sub
'<<=============

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module:

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman


"Jaydubs" wrote in message
...
Hello Excel(lent) users,

I have made a file with a number of tabs. One of those tabs is called
Menu.
In that tab I have made links to different other tabs. Now I want the file
to
open always with that tab, regardless of how it has been saved the
previous
time. Is there an easy way to do this??

Thanks kindly!!
--
** Fool on the hill **