opening on same sheet

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

When I open my excel program if i have been I want it to
always open in the same worksheet i am using
Private Sub Workbook_Open()
Worksheets("names").Show
End Sub
it is telleing me i have the wrong code. What am i
missing?
 
Hi
try
Private Sub Workbook_Open()
Worksheets("names").activate
End Sub
 
You must log in or register to reply here.

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

Can't delete sheets 8
How to set focus on an ActiveX ListBox 7
Excel VBA - Problem with Closing Print Preview 0
Set Active Cell to A1 on Open Q 3
Using Container in Auto open macro 2
Q - Open Specific Sheet 3
Conflicting VBA Coding 7
Copying cells and formula from closed workbook to all sheets in open workbook 0

Back
Top