Thread
:
Opening a tab automatically in a file
View Single Post
#
2
Posted to microsoft.public.excel.misc
Nick Hodge
Posts: n/a
Opening a tab automatically in a file
You can implement a workbook_open() macro like so
Private Sub Workbook_Open()
Worksheets("Menu").Activate
End Sub
To paste this in, right click on the Excel Icon for the workbook (NOT the
application one) and select view code... Paste it here, save and close
workbook, now every time it open it will go to the Menu worksheet
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS
"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 **
Reply With Quote