| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Open Workbook Formula
Press Alt-F11 to open VB Editor
Double click on 'ThisWorkbook' on the left Paste this macro in the right pane after replacing Sheet2 with the name of the sheet you want to open to Private Sub Workbook_Open() Worksheets("Sheet2").Activate End Sub "Gia" wrote: I need a formula for when a workbook is opened it will default to a specific tab. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| Need VB code for workbook open to open a link | Excel Discussion (Misc queries) | |||
| Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
| Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
Hybrid Mode
