setting up worksheet to open at the top

  • Thread starter Thread starter Lance
  • Start date Start date
L

Lance

In the open or save event you can add the line
example:

Private Sub Workbook_Open()
ActiveSheet.Cells(1, 1).Select
End Sub
 
Lance,


Sorry for my ignorance- but can you give me the steps to
do this, I have no
idea where to save an event. Is this in VB?


Thanks,

Michelle
 

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

Where best to place an instruction in a VBA script 4
Open workbook to same worksheet and next empty row 3
runtime error 2147221005(800401f3) 1
once only pop up 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Find Method problem in Excel VBA.... 7
Flatten password file 3
Userinterfaceonly 5

Back
Top