Thread: splash screen
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default splash screen

Hi,

Things have move on since autoexec.bat!!

In Excel you use the worksheet_open event. Alt+F11 then double click
workbook and paste this in.

Private Sub Workbook_Open()
Worksheets("Menu").Select
End Sub

Mike

"K11ngy" wrote:

Would someone kindly advise code I need to write in macro so that when I open
Excel it opens with a particular worksheet (Main menu) I assume I would also
name macro "Autoexec" ??

Thanks

Steve King