Opening file to a certain worksheet

  • Thread starter Thread starter carljonesuk
  • Start date Start date
C

carljonesuk

I need excel to open to a certain worksheet so that i can run a macro t
adjust every other sheet to users screen resolution.

How do i do this?

Any help would be useful!

Thanks
 
Hi
not quite sure what you want but if you want to activate a specific
sheet for one workbook put the following code in the workbookmodule of
this excel file:
Private Sub Workbook_Open()
Worksheets("Sheet3").Activate '-> activates sheet3 on startup
End Sub

Frank
 
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

Cannot copy worksheet to another file 2
Running macro on certain worksheets 0
Tracking Access in Read-Only Files 0
Code to format cells on several worksheets 2
worksheet renames - specific 0
sum across worksheets conditionally 5
Certain worksheets won't print 1
insert an instruction for users when a worksheet opens 2

Back
Top