Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On open workbook go to a specific worksheet
On opening a workbook I would like it go to a specific worksheet e.g. index
page. Is there a macro that will perform this function please? Thank you for your assistance. Andy Josolyne |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
On open workbook go to a specific worksheet
Sub Auto_open()
Sheets("Index").Activate Cells(1, 1).Select End Sub HTH. Best wishes Harald "Andy Josolyne" skrev i melding ... On opening a workbook I would like it go to a specific worksheet e.g. index page. Is there a macro that will perform this function please? Thank you for your assistance. Andy Josolyne |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
On open workbook go to a specific worksheet
Harald
Many thanks for your fast response. Where do I store the macro - in a new one, or in the code stores in the Excel icon? "Harald Staff" wrote: Sub Auto_open() Sheets("Index").Activate Cells(1, 1).Select End Sub HTH. Best wishes Harald "Andy Josolyne" skrev i melding ... On opening a workbook I would like it go to a specific worksheet e.g. index page. Is there a macro that will perform this function please? Thank you for your assistance. Andy Josolyne |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
On open workbook go to a specific worksheet
Hi
In the workbook itself. Open it, then open the VB editor (Alt F11 or similar). Insert Module, paste it in, save. HTH. best wishes Harald "Andy Josolyne" skrev i melding ... Harald Many thanks for your fast response. Where do I store the macro - in a new one, or in the code stores in the Excel icon? "Harald Staff" wrote: Sub Auto_open() Sheets("Index").Activate Cells(1, 1).Select End Sub HTH. Best wishes Harald "Andy Josolyne" skrev i melding ... On opening a workbook I would like it go to a specific worksheet e.g. index page. Is there a macro that will perform this function please? Thank you for your assistance. Andy Josolyne |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
On open workbook go to a specific worksheet
Store it in a standard code module.
Go into the VBE (Alt-F11), and from the men, InsertModule. -- HTH RP (remove nothere from the email address if mailing direct) "Andy Josolyne" wrote in message ... Harald Many thanks for your fast response. Where do I store the macro - in a new one, or in the code stores in the Excel icon? "Harald Staff" wrote: Sub Auto_open() Sheets("Index").Activate Cells(1, 1).Select End Sub HTH. Best wishes Harald "Andy Josolyne" skrev i melding ... On opening a workbook I would like it go to a specific worksheet e.g. index page. Is there a macro that will perform this function please? Thank you for your assistance. Andy Josolyne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Workbook on Specific Worksheet | Excel Discussion (Misc queries) | |||
OPEN A WORKBOOK TO A SPECIFIC WORKSHEET | Excel Discussion (Misc queries) | |||
Open Workbook to Specific Worksheet? | Excel Discussion (Misc queries) | |||
How to open a workbook on a specific worksheet. | Excel Worksheet Functions | |||
Open workbook to specific worksheet | Excel Discussion (Misc queries) |