Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA help
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA help
PANCAKE, If you enter the following in the workbook area (ALT + F11, doubleclick on ThisWorkbook in project window( CTRL + R if not visible)) Copy this in to the ThisWorkbook code window Private Sub Workbook_Open Sheets("Start").Select Range("A1").Select End Sub You should then be directed to this page when the workbook is opened (as long as Macro enabled) Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA help
thanks for the help -- PANCAKE ------------------------------------------------------------------------ PANCAKE's Profile: http://www.excelforum.com/member.php...o&userid=36157 View this thread: http://www.excelforum.com/showthread...hreadid=572986 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|