Open Workbook Formula

H

Harlan Grove

Gia said:
I need a formula for when a workbook is opened it will default to a specific
tab.
Click to expand...

Formulas can't do this. Only macros can. Can you use macros? If so, in
the ThisWorkbook class module create a Workbook_Open event handler
macro like

Private Sub Workbook_Open()
Me.Worksheets("worksheet name here").Activate
End Sub
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Turning off automatic calculation 0
Password protect new workbooks from template 0
offset formula causing Circular reference 0
Link To File That No Longer Exists 1
How do I link a cell in a workbook? 1
Use a master workbook to carry over changes to multiple workbooks 1
Need VB formula to exit workbook 1
Sumif apllying to all sheets in workbook 2

Top