Thread: VBA help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default VBA help

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

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"PANCAKE" wrote in
message ...

Hey

Is there a way when people are opening a document that they always
comming to the same workblad i wont?

For example:

I have a excel document whit a lot of spreadsheets in it and i want
that when they open the document they always get to the first
spreadsheet named start.

greets


--
PANCAKE
------------------------------------------------------------------------
PANCAKE's Profile:

http://www.excelforum.com/member.php...o&userid=36157
View this thread: http://www.excelforum.com/showthread...hreadid=572986